Oracle Indexes Demystified

Course Code: ORAIND
Currency: 10g & 11g
Duration: 1 day
Audience: Database administrators, system administrators and performance analysts.
Prerequisites: Working knowledge of Oracle architecture, processes and schema objects.
Summary: This course discusses all of the Oracle index options:
  • B*tree
  • Bitmap
  • Hash
  • Partitioned
  • Index clustered table
  • Etc.
in the following contexts:
  • Structure and organisation
  • How to choose
  • Column selectivity
  • Maintenance
  • Performance
  • Monitoring
  • OLTP vs. data warehousing
Objectives: Upon completion of this presentation, the delegate should be able to choose amongst index options so as to optimise processing in OLTP and data warehousing environments.
View full outline in PDF formatDetailed Outline

print  |  top of page