CODEWITHSUNDEEP
sql-serverperformance
Mahesh KP
Mahesh KP

Reputation: 6446

Indexing using Database Engine tuning advisor

We got a requirement to index a database. We planned to use db engine tuning advisor to get index recommendations. When we analyse the script using database tuning advisor we got both index recommendations and statics recommendations.

Whether we have to consider both index recommendations and statics recommendations to get the tabled indexed? Or what actually the statistics recommendations meant?

Mahesh

Upvotes: 3

Views: 1164

Answers (1)

John Sansom
John Sansom

Reputation: 41819

You can "consider" both the index and statistical recommendations.

What you should look to do is evaluate the changes that are being proposed to understand why they are being recommended to you. Then using your judgement, test the changes which you have identified as being plausible, on a non production server.

Are you using the DTA to analyse a single T-SQL Script or are you running a representative workload though?

If you are looking at just single script consider that the tuning recommendations are isolated to just the specific case you are looking at and you cannot factor in how other queries will be affected by the proposed changes.

Upvotes: 3

Related Questions