The info like total optimization time, the time spent on each stage of optimization, the number of alternative plans and the cost of each alternative plan. Is there any way to get these info using sql server 2008?
Sql-server – How to get the information of the optimizer of sql server
optimizationsql server
Related Question
- Sql-server – How Should I Configure Memory for Multiple Instances of SQL Server
- Postgresql – How to get the information of the optimizer of PostgreSQL
- Sql-server – ny way to prevent the memo structure from being pruned
- SQL Server 2014 – SET Options Affecting Plan Reuse and How to Get Their Values
- Sql-server – SQL Server Query Optimizer Time Spent and Numbers
- MongoDB Optimization – How Does the Query Optimizer Evaluate Candidate Plans?
- SQL Server – How to See Candidate Execution Plans Generated by Query Optimizer
Best Answer
You should check out the SQL Management Studio
It will let you see many things about your query. I know it will show you the cost of executing the query. It will also show you the cost of each step of the execution.
http://msdn.microsoft.com/en-us/library/ms178071(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms191194(v=sql.105).aspx