Identify the reason why chained or migrated rows in a table cause performance degradation when you access them.
Posted: Sun Jun 11, 2023 3:49 pm
Identify the reason why chained or migrated rows in a table cause performance degradation when you access them.
A. because the ROWID changes for these rows
B. because these rows make existing indexes invalid
C. because it is not possible to use indexes to retrieve these rows
D. because retrieving these rows requires more than one data block to be accessed E. because the rows force queries to use temporary segments while retrieving them
A. because the ROWID changes for these rows
B. because these rows make existing indexes invalid
C. because it is not possible to use indexes to retrieve these rows
D. because retrieving these rows requires more than one data block to be accessed E. because the rows force queries to use temporary segments while retrieving them