Oracle DB Optimization Question:

Tell me what is Index tuning?

Tweet Share WhatsApp

Answer:

Index tuning is part of database tuning for selecting and creating indexes. The index tuning goal is to reduce the query processing time. Potential use of indexes in dynamic environments with several ad-hoc queries in advance is a difficult task. Index tuning involves the queries based on indexes and the indexes are created automatically on-the-fly. No explicit actions are needed by the database users for index tuning.

Download Oracle Database Optimization PDF Read All 8 Oracle Database Optimization Questions
Previous QuestionNext Question
Explain some disadvantages of the Indexes?Tell me in brief the cursor optimization tips?