Skip to Content
Former Member
Aug 07, 2007 at 07:17 PM

Order of field in an open sql where clause ?


Hi experts,

I would like to know if the order of field in a SELECT where clause has an impact on the index choice. For exemple, for a table with three fields in the primary index, does it matter to specify:

WHERE tab-field1 = x AND tab-field2 = y AND tab-field3 = z


WHERE tab-field3 = z AND tab-field2 = y AND tab-field1 = x

Does both where clause take the primary index? Is there any performance issue here ? If so, could anybody tell me where I could find documentation about that ?

Thanks, for your time, I'll reward points.