Indexes are fundamental to every Oracle database and are crucial for optimal performance. However, there’s often much misconception and misunderstanding regarding how Oracle database indexes function and should be maintained.
Things can become even more confusing when one considers new indexing capabilities introduced with the Oracle 12c Database, Oracle engineered solutions such as Exadata and new database options such as the In-Memory Database option.
This is a wonderful opportunity to both learn and ask index related questions in an open forum directly to Richard Foote, a highly-respected Oracle indexing expert, well known for his Oracle Indexing blog and many public presentations and seminars on this subject.