Identify the reason why chained or migrated rows in a table cause performance degradation when you access them.

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Identify the reason why chained or migrated rows in a table cause performance degradation when you access them.

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply