Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kimi86
Yak Posting Veteran
79 Posts |
 Posted - 2012-07-19 : 13:46:37
|
| Guys i really need help with my really slow queries.There is a view which is performing really badlyCan somebody plese help me with following1. How to check what indexes are being used2. How to check if rebuilding an index will help3. See index recommendations 4. How to check impact adding an index will have in the execution I now these things can be done in ssms but now sure how.. Please please help me.. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-07-19 : 13:52:32
|
| 1. Select the option to include the execution plan and then run your query. It's in the query menu.2. Test the query before and after the rebuild.3a. I use this for general purposes, but you have to be VERY CAREFUL with it!:http://sqlserverpedia.com/wiki/Find_Missing_Indexes3b. SSMS also can make recommendations if you include the execution plan.4. Test, test, test. I use SET STATISTICS IO ON and SET STATISTICS TIME ON.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Please help me with execution plans!!