Joined: 30 Sep 2006
I need help ond DB2 performance.
I have table T1 index is IX on columns C1, C2, C3, C4 .
right now the sql in the program is
Select * from T1
Where C1 = 1
and C3 = 3
and C4 = 4
and C2 = 2
program is using the index columns in the where clause,
but the index order is C1,C2, C3, C4 but the where cluase is using
Is that matter to performance?.