Oracle Tutorial – B-Tree Indexes: What, Why and More

What are Oracle indexes? How do they work? What is a b-tree index? When should you use them? When should you avoid creating indexes? Learn about function based, reverse key and descending key. And index maintenance including coalesce versus rebuild. Learn with demonstrations and examples.

Presenter: Oracle Certified Master DBA John Watson
This free tutorial on Oracle Database indexes is segmented into several separate lessons:

  1. Agenda (1:10) (click on video below)
  2. What are B-Tree Indexes (10:14)
  3. The Organization of B-Tree Indexes (6:05)
  4. Index Maintenance and Block Splits (3:40)
  5. Composite Key Indexes (6:13)

Date: Oct 11, 2017