| 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
|