- Use column names instead of * in SELECT query
- Reduce the use of temp tables created in the SP, delete the tables once their use is over.
- Create indexes on frequently queried columns,
- use JOIN statements instead of sub-queries or correlated sub-queries.
![](https://i0.wp.com/referbruv.com/wp-content/uploads/2022/05/banner-image-questions-new.png?fit=1200%2C600&ssl=1)
How can you performance tune a Stored Procedure?
- Use column names instead of * in SELECT query
- Reduce the use of temp tables created in the SP, delete the tables once their use is over.
- Create indexes on frequently queried columns,
- use JOIN statements instead of sub-queries or correlated sub-queries.