A table named Student has columns named ID, Name, and Age. An index has been created
on the ID column. What advantage does this index provide?
A.
It reorders the records alphabetically.
B.
It speeds up query execution.
C.
It minimizes storage requirements.
D.
It reorders the records numerically.
Explanation:
Faster to access an index table.
B is the correct answer of which its its speeds up query execution faster to access index table
B: Speed up query execution