1. patel_mayur New Member

   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
   

   patel_mayur, Feb 2, 2006

   #2
2. Madhivanan Moderator

   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

   Madhivanan, Feb 2, 2006

   #2
3. patel_mayur New Member

   Thanks a lot Madhivanan !!!

   patel_mayur, Feb 2, 2006

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in