Indexing with Database Tuning Advisor

We have a requirement to index the database. We planned to use the db tuner tuning advisor to get recommendations on the index. When we analyze the script with the help of a database configuration advisor, we received recommendations on indexes and recommendations on statistics.

Do I need to consider index recommendations and static recommendations to get indexed text? Or what did the statistics recommendations really mean?

Mahesh

+3
source share
1 answer

You can "consider" both index and statistical recommendations.

, , , , . , , , , .

DTA T-SQL Script ?

Script, , , , , .

+3

Source: https://habr.com/ru/post/1794408/


All Articles