Hi, 10th May 2001 16:47 hrs chennai

say for a you have created index for a table having columns
a,b,c,d.

If you have created Index on a,b,c i.e composite index and if you use b column in a SQL statement then it wont use indexing.

if you use the first column a alone or as a,b,c in condition as required then the index will be used.

as for as Nealh says i contradict do you meant to say indexing was not used. ?

How mcuh record you had in the table did you analyze the index usage ?

Cheers

Padmam