Index Tuning Wizard for Microsoft SQL Server 7.0 (and the AutoAdmin Project)

Surajit Chaudhuri


The long term goal of the AutoAdmin initiative at Microsoft is to make databases self-tuning and self-administering. In order to achieve this goal, we exploit execution as well as optimization information of the workload experienced by the database system. Despite being a relatively young project, our innovations have already enriched Microsoft SQL Server's upcoming release. The index tuning wizard in SQL Server 7.0 is a contribution of the AutoAdmin project. In this talk, I will provide an overview of the AutoAdmin effort, present a demonstration of the Index Tuning Wizard using SQL Server 7.0, and discuss the technical details of the index tuning technology we developed.


Surajit Chaudhuri initiated and leads the AutoAdmin project at Microsoft. Prior to joining Microsoft, he worked at Hewlett-Packard Laboratories, Palo Alto. He holds a Ph.D from Stanford University. Surajit has worked extensively on optimization of decision-support queries as well as on integration of relational and IR query systems. He is also involved with systems issues in Data Mining. For more details, see