Index tuning & database partitioning

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.