Which of the following is an advantage of creating indexes?

Question

Options

• ATo help with space allocation
• BTo provide quick and efficient access to data
• CTo reduce memory
• DTo update the query plan

• A
  3% (1)
• B
  94% (29)
• C
  3% (1)

Explanation

Indexes are data structures that allow a database engine to locate rows without scanning an entire table, making reads significantly faster - this is their primary purpose, making B correct. Option A is wrong because indexes actually consume additional disk space rather than helping allocate it. Option C is wrong because indexes typically increase memory usage, as the engine loads index pages into the buffer cache. Option D is wrong because while the query optimizer uses indexes when building query plans, creating an index doesn't itself update the query plan - the plan is generated fresh at query time.

Memory tip: Think of an index like a book's index in the back - it doesn't change the book's size story (A), doesn't save paper (C), and doesn't rewrite the table of contents (D) - it simply lets you find information fast (B).

No community discussion yet for this question.