Lists become an imperative factor if the tables included in the query have a large number of columns. Also, it impacts when complex database queries get terminated by the application. The most ideal approach to get recommendations on required indexes is to check the query execution plan. While analyzing the SQL queries for indexing, we must anticipate every one of the genuine queries separately.
While working with indexes, it must be noted that:
- Indexes might slow down inserts and updates, so apply them carefully on columns that are frequently updated
- Indexes are meant to speed up search operations that use WHERE and ORDER BY clauses in the query