Does the order of coding elements in your IN list matter?

(Klaas Brant) If IN list column is indexed (and chosen as a matching column), DB2 Sorts IN list into ascending sequence, removing duplicates. The IN list values are then used to probe the index to find the matching rows. Thus order of elements is irrelevant for an IN list that is chosen for IN list

Read More - Register for Free Membership