Tips to improve SQL query performance

1. Avoid usage of multiple joins in a single query. Unnecessary joins degrade your query performance.

2. Creation of indexes on the table. Indexes are used for improving your queries. We need to create the indexes Read more…