# 9 Tricks for Boosting SQL Query Performance ## Metadata - 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)