What is the purpose of the REINDEX command and when should it be used?

Advanced SQL Developer Hard

Advanced SQL Developer — Hard

What is the purpose of the REINDEX command and when should it be used?

Key points

  • REINDEX rebuilds the index entirely
  • Used for corrupt or bloated indexes
  • Necessary after changing index parameters
  • Ensures index performance is maintained

Ready to go further?

Start full exam Practice more questions

Related questions