- Author: Anisuzzaman Babla
- Full Title: 9 Tricks for Boosting SQL Query Performance
- Category: #Type/Highlight/Article
- URL: https://medium.com/p/2c03ea4873b2
Highlights
- The best approach here is to define the fields in the SELECT statement to instruct the database to query only the required data to meet the end goals.
- Performance tuning in SQL can be done by indexing properly, which translates to quicker access to the database during critical times. This
- It is highly recommended to avoid using temp tables if your code can be written simply
- Create Joins With INNER JOIN (not WHERE)