We have a table with 5 columns in the index. In the where clause, only the first column of index appears, I want to know why it doesn't use the index but full-scan instead.
Thanks.

Queyon