Hi all,
When i run tuning advisor in sql server. It gives some statistics .Is it useful??? How to use this?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jaganathan BantheswaranPosted Oct 28, 2013, 2:38 AM
Tuning Advisor in SQL Server is a tool to tune your DB for your Environment.
In a DTA gives you the statistics that will enhance query performance; like,
Adding indexes (clustered, nonclustered, and indexed views)
Adding partitioning
Adding statistics including multi-column statistics which are not created automatically even when you have the AUTO_CREATE_STATISTICS database option set to ON
For more read these,