Performance Archives

Improve SQL query performance

Author - Banita Rani

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…