Vallabhaneni
New User
Joined: 30 Sep 2006 Posts: 5
|
|
|
|
Hello,
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
C1,C3,C4,C2
Is that matter to performance?.
Please clrify
Thank you |
|