-
Index tuning using sql script
Is it possible to achieve Index tuning using sql script within Query Analyser when being just a db_owner and not sysadmin.
In case the answer is yes, would you please provide any link to help or examples.
Thanks
-
What's 'Index tuning using sql script within Query Analyser'?
-
I mean writting a SQL script to do the tuning instead of using the wizzard??
-
Can't do that with sql script.
-
You can however run the query in query analyzer and see execution plan, it will indicate where you are doing full scans or which statistics are missing.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|