Index tuning & database partitioning interview questions
What is “Index Tuning Wizard”?
Index Tuning Wizard is a software application that identifies tables which have
inefficient indexes. It makes recommendations on how indexes should be built on
a database to optimize performance. The recommendations are based on T-SQL
commands that the wizard analyzes.
List out what Index Tuning Wizard can do.
-
It identifies tables in need of an index change
-
Implements recommendations
-
Determines how a proposed change might affect performance
-
Has the capability to make indexes change immediately and schedule them
-
Helps to tune indexes.
Explain how partitioning an important part of database optimization is.
Partitioning distributes database tables over different database which may
reside on a different server. Vertical portioning helps to fit more rows on a
database page to improve data access performance. Partitioning helps to do
multiple tasks simultaneously. It increases performance. It helps to manage
data.
|