Answer
Use highly selective, narrow, composite indexes. Avoid indexing low-cardinality columns and review real query patterns regularly.
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ