Skip to Content
0
Former Member
Jan 05, 2010 at 09:00 PM

Impact of Order of fields in Secondary index

1040 Views

Hi all,

I have a doubt that wether the order of fields and number of fields cause any impact on performance.

Like if I am creating a secondary index Z01 for some table X with fields a,c,b,d,e,h,f and in my select query the where clause is like a,b,c only will it will redume my performance.

Thanks in Advance,

Anmol.

Moderator message - Moved to the correct forum

Edited by: Rob Burbank on Jan 5, 2010 4:14 PM