Multiple choice technology databases

Indexes and statistics are built ________________ the exchange of the exchange table ?

  1. After

  2. Before

  3. In either way

  4. Not Relevant
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To perform a partition exchange, the exchange table must have matching indexes and statistics built before the exchange. This allows Oracle to swap metadata instantly without needing to rebuild indexes on the destination partitioned table. Building them after or during the exchange is not feasible because the structures must align beforehand.

Keep practicing — related questions