Oracle
1Z0-417 · Question #88
Which are two characteristics of "invisible" index functionality that would help tune a database having thousands of legacy indexes?
Sign in or unlock 1Z0-417 to reveal the answer and full explanation for question #88. The question stem and answer options stay visible for context.
SQL Tuning
Question
Which are two characteristics of "invisible" index functionality that would help tune a database having thousands of legacy indexes?
Options
- AAn invisible index is ignored by the optimizer.
- BAfter an index becomes invisible, it is no longer maintained during inserts and updates.
- CI/O bottlenecks are easy to spot when invisible indexes are used.
- DAn index only needs to be rebuilt for it to be visible again.
- EThe session or system parameter needs to be changed to
Unlock 1Z0-417 to see the answer
You've previewed enough free 1Z0-417 questions. Unlock 1Z0-417 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#invisible indexes#optimizer#index management#legacy indexes