Database Tuning Advisor (DTA) is a physical database design
tool that is part of Microsoft’s SQL Server 2005 relational
database management system. Previously known as “Index
Tuning Wizard” in SQL Server 7.0 and SQL Server 2000, DTA
adds new functionality that is not available in other contemporary
Commercial database management systems support many physical design alternatives such as indexes