Best practices for Indexing Create index on columns that are frequently used for data retrieval or in filter conditions. For example in SELECT statement and WHERE clause or in ORDER BY , GROUP BY , and DISTINCT clauses. As i…