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 !!!