Multiple choice technology databases

When we do not prefer to create index

  1. A column contains large no of values

  2. A column contains large no of null values

  3. Table is small

  4. When table is not updated frequently
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Indexes provide performance benefits primarily on large tables by speeding up data retrieval. On small tables, the overhead of maintaining the index outweighs any performance gain, and a full table scan is already fast. Options A and B are actually scenarios where indexes might be useful (high cardinality columns), while Option D is incorrect because indexes are beneficial regardless of update frequency.

Keep practicing — related questions