After migration, a warehouse workload keeps every legacy index and forces index plans for large scans. What should the tuning review do?

Published
  1. Compare measured indexed access with eligible Exadata Smart Scan plans.
  2. Assume every legacy hint remains optimal on the new platform.
  3. Disable statistics collection permanently.
  4. Drop every index without checking selective OLTP queries.

Comments — 0