Tuning is the process or technique which is used for ensuring that the SQL statements that an application will issue will run in the fastest possible time. In Tuning there may be ten different ways to execute a query. Database Engine Tuning Advisor is a tool for analyzing workloads involved in database functioning. It enables the tuning of databases for improved query processing and the creation of an optimal set of indexes, indexed views and partitions. These functions do not require a deep understanding of database structure or SQL server internals. Database Engine Tuning Advisor closely examines how queries are processed in a database and recommends methods to improve query processing.