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 |
|
malachi151
Posting Yak Master
152 Posts |
 Posted - 2011-10-08 : 06:15:47
|
| Correct me if I'm wrong, but the Database Engine Tuning Advisor only works on SELECT queries right, not DML statements? If so, how do you tune DML statements that involve extensive use of subqueries and joins? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-08 : 07:18:41
|
| one way is to run statement with execution plans on and seeing index recommendations given------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Tuning Advisor for UPDATE, INSERT, DELETE?