topic Order in where clause - SQL statement in Application Development and Automation Discussions

Order in where clause - SQL statement

Former Member — Wed, 08 Aug 2007 19:33:43 GMT

Hi,

The order of the fields in Where clause in OpenSQL statements is important to get the right index?

Select a b c from t1

where

d = p_d and

e = p_e

Select a b c from t1

where

e = p_e and

d = p_d

Index:

columns e and d.

Thanks !

Re: Order in where clause - SQL statement

Former Member — Wed, 08 Aug 2007 19:35:34 GMT

HI,

Both will give you the same result.. but it is always good to pass the sequence as in the table.. the performance will be good when you follow the sequece of occurance of the fields.

Thanks

Mahesh

Re: Order in where clause - SQL statement

Former Member — Wed, 08 Aug 2007 19:36:06 GMT

It should be better to provide the fields for the WHERE statement in order...That way the table can be accessed faster.

Greetings,

Blag.

Re: Order in where clause - SQL statement

Former Member — Wed, 08 Aug 2007 19:38:21 GMT

This is a duplicate post - please check my answer in the other one.

Rob

Re: Order in where clause - SQL statement

Former Member — Wed, 08 Aug 2007 19:58:21 GMT

Thank you!!