use of composite indexes

[sqluser99]

Hi,

Suppose there is a composite index on a table, and in includes, for example 3 columns.

If I do a select using one of those three columns, will the select use the composite index? Will it aid in retrevial or should I create an index on the
individual column.

any thoughts on this would be appreciated.



thanks

[Rawhide]

Enter your query in Query analyzer and view the estimated execution plan. What does it say in there? Is it doing an index scan/seek or a table scan?

[rmiao]

Depends on which column you query for. If you don't use first column in the index in where clause, optimizer will not use that index.