Multiple choice technology databases

What is meant by an index scan

  1. When an entire index is scanned to locate rows we call it as index scan

  2. When only part of the index is scanned to locate rows we call it as index scan

  3. When all the rows are scanned we call it as index scan

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

An index scan occurs when DB2 accesses and searches the index structure itself to locate the requested rows, rather than scanning the entire tablespace.

Keep practicing — related questions