8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Multiple Indexes on the Same Set of Columns in Oracle Database 12c Release 1

Javid Hasanov said...

Dear Tim,

Thank you for sharing your knowledge with us.
Can u please, add section regarding interaction multiple indexes on the same column with parameter OPTIMIZER_USE_INVISIBLE_INDEXES.

Best Regards.

Tim... said...


Done. It is similar to any invisible index. They become visible and the optimizer can chose which one best suits the task.



DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.