Which database function improves data retrieval speed by creating an efficient access structure?

Options

  • A. Indexing
  • B. Data deletion
  • C. Transaction rollback
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. Indexing

Detailed Explanation

  • Indexing: Creates an additional data structure to speed up data retrieval.
  • Indexes can reduce the need to scan every row in a table.
  • Indexes require additional storage and may slow down some write operations.