question related to select statement

[Former Member]

Hi All,

If the field mentioned in where clause of select statement are not in sequence as available in database.Will it affect the performance.

Thanks and Regards,

[Former Member]

Hi,

if any index exist in that order it will not affect the performace...else create one to avoid performance bottleneck.

regards,

madhu

[Former Member]

i think it wont be any criteria of sequence in where clause but which field you are using in where that is important.

regards

shiba dutta

[Former Member]

No, It will not generate any performance issue.

Cheers

[former_member181962]

Hi Praveen,

It does have an effect. I have noticed the same in one of my programs recently.

If you don't know the correct order, declare in the order they appear in the se11.

Regards,

Ravi

[Former Member]

it is good that u specify the sequence order...<b>This reduces time sometimes</b>...If u dont know u can specify in random order...this is not a problem.