1. Create indexes
2. Create clustered indexes
3. Create non-clustered indexes
4. Drop indexes that are not used
5. Use table partitioning
6. Use temp table and table variables where ever necessary . Do not query on master table
7. Avoid the use of cursors
8. Evaluate the execution plan
9. Rebuild indexes periodically
10. Remove outer joins
11. Remove unnecessary tables
12. Only select Fields which you need
13. Do not use NOT IN clause
14. Use SET NOCOUNT ON with DML operations
15. Aviod use of Group by , order by and distinct
16. Use Try and Catch block
17. Avoid multiple joins
Happy learning :)
2. Create clustered indexes
3. Create non-clustered indexes
4. Drop indexes that are not used
5. Use table partitioning
6. Use temp table and table variables where ever necessary . Do not query on master table
7. Avoid the use of cursors
8. Evaluate the execution plan
9. Rebuild indexes periodically
10. Remove outer joins
11. Remove unnecessary tables
12. Only select Fields which you need
13. Do not use NOT IN clause
14. Use SET NOCOUNT ON with DML operations
15. Aviod use of Group by , order by and distinct
16. Use Try and Catch block
17. Avoid multiple joins
Happy learning :)
Comments
Post a Comment