Which is false?
-
a) An index must exists for the columns associated with the sort ield(s) specified in the Sort Specification.
-
b) To use the index, the sort fields should be in the same order as the columns in the index
-
c) If a sort specification uses columns from two different tables, both index will be used.
-
d) If a sort specification uses columns from two different tables, no index will be used.
Reveal answer
Fill a bubble to check yourself
C
Correct answer
Explanation
When sorting spans multiple tables, database engines cannot effectively use indexes because the sort operation requires combining data from different sources. Indexes work best for single-table sorts where column order matches. Option C is correctly identified as false - using both indexes simultaneously would be inefficient and is not supported.