🎴 Flashcard Mode
Oracle Database: Exadata and SQL Essentials
Card1 / 20
Mastered0
Review0
QuestionClick to flip
In which scenario would an index be most useful?
AnswerClick to flip back
A
The indexed column contains a wide range of values.
💡 Explanation:
Indexes are most effective on columns with high cardinality - many distinct values relative to total rows. Low cardinality columns (like gender with only 2-3 values) see little benefit from indexing because each index entry points to many rows.