Which Index Sql use ? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Which Index Sql use ?

Hi All: How can we know that which Cluster/Noncluster indexes is used by SQL Server for a particular Query. Also, can anybody point out how to read/study query execution plan ? Thanks in advance

When running the query set the execution plan and see
http://www.sql-server-performance.com/query_execution_plan_analysis.asp Madhivanan Failing to plan is Planning to fail
Thanks a lot Madhivanan !!!