Home >
Oracle >
Oracle Indexes Demystified
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.
|
Detailed Outline |
|