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

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

 

×