Hi, I'm running SQL 2000 and I have a table with an index1 on ID1 and ID2, in that order. Select count(distinct(id)) from table returns 1 and Select count(distinct(id)) from table has all the values of the table. The querys to that table uses "... where id1= XX and id2 = XX " Could it make any performance improvement if I switch the order of the fields of index1 ? Or is it indifferent because id1 has only 1 value? Thanks for your time!