Oracle DB Optimization Question:

Tell me what is Index tuning?

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.


Previous QuestionNext Question
Explain some disadvantages of the Indexes?Tell me in brief the cursor optimization tips?