Video : Invisible Indexes in Oracle Database 11g Onward

In today’s video we’ll discuss Invisible Indexes, introduced in Oracle 11g.

The video is based on this article.

The star of today’s video is Chris Muir, who was instrumental in me becoming a presenter. He invited me down to Australia to speak at a couple of AUSOUG events, which were the first proper conferences I ever presented at.

Cheers

Tim…

11g bits and bobs…

I’ve just released an article covering the Miscellaneous New Features section of the OCP upgrade exam. It contains a rather random assortment of stuff including:

  • Online Table Redefinition Enhancements
  • Enhanced Finer Grained Dependency Management
  • DDL With the WAIT Option (DDL_LOCK_TIMEOUT)
  • Invisible Indexes
  • Query Result Cache
  • Adaptive Cursor Sharing
  • Temporary Tablespace Enhancements

I was toying with the idea of putting each section out as separate articles, but they’re all pretty small soundbites, so I thought I would be better to stick with grouping in the OCP syllabus.

Cheers

Tim…