Database Tuning Advisor (henceforth, DTA) is part of Microsoft SQL Server 2005 [1]. DTA automates the selection of indexes and materialized views and horizontal partitioning of both data and indexing structures and takes both performance and manageability into account when arriving at the best physical design. DTA distinguishes itself from other existing physical design tools in following ways.