SQL Server Performance Improvment Tuning Query

SQL Server Performance Improvment Tuning Query

Tuning Query i.e. Optimize query for speed process

1. Open Query and Save Query in disk

2. Open Query Database engine tuning advisor

3. Start new Session and select query which is saved in step 1 and Start Analysis

4. After Running Analysis it will provide list of recommendation as follows

5. Click and copy Definition and Create it another query window.

It could be any non clusters index or STATISTICS on table