Table index is one of the most important areas, while optimizing a query.
Here is the best practice of using these indexes, to get the optimal performance gain.
1. Consider creating indexes 'only' on those columns which are frequently used in WHERE, ORDER BY and GROUP BY clauses.
2. Do not create duplicate or un-necessary indexes. These indexes hampers insert, delete and update performance of any query. Consider dropping any such indexes, if already there.
3. Make sure table/index statistics are updated regularly.
Here is the best practice of using these indexes, to get the optimal performance gain.
1. Consider creating indexes 'only' on those columns which are frequently used in WHERE, ORDER BY and GROUP BY clauses.
2. Do not create duplicate or un-necessary indexes. These indexes hampers insert, delete and update performance of any query. Consider dropping any such indexes, if already there.
3. Make sure table/index statistics are updated regularly.
