Oracle Indexes Demystified
Short course
In Gatwick
Description
-
Type
Short course
-
Location
Gatwick
-
Duration
1 Day
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. Suitable for: Database administrators, system administrators and performance analysts.
Facilities
Location
Start date
Start date
About this course
Working knowledge of Oracle architecture, processes and schema objects.
Reviews
Course programme
Currency:
10g & 11g
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.
Oracle Indexes Demystified