Database administrators often use ________ to identify unused or redundant indexes and optimize database performance.
- Database normalization
- Index fragmentation
- Index tuning
- Query optimization
Database administrators often use index tuning to identify unused or redundant indexes and optimize database performance. This involves analyzing query patterns and the effectiveness of existing indexes to make informed decisions.
Loading...
Related Quiz
- How does normalization affect data integrity compared to denormalization?
- How does a data governance framework differ from a data management framework?
- Which of the following is a common technique used for data extraction in the ETL process?
- Which consistency model is typically associated with NoSQL databases?
- Which execution mode in Apache Spark provides fault tolerance for long-running applications?