2. |
Under which conditions is it beneficial to physically re-sequence table rows?
Please select all the correct answers.
|
|
A.
|
In tables that access rows via ROW ID
|
|
B.
|
In tables that access rows via full-table scans with ORDER BY
|
|
C.
|
In tables that access rows via index range scans
|
|
D.
|
In tables where a single index is used by the majority of queries
|