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,
Moderator message - Moved to the correct forum
Edited by: Rob Burbank on Jan 5, 2010 4:14 PM