Course Overview
In this one day seminar, Uwe Hesse will review some of the key aspects of partitioning across all versions, including some new features of 12c.
Learn About:
- Partition Pruning.
- Rolling Window.
- Interval Partitioning.
- Compressed Partitions.
- Exchange Partition.
- Partition Indexes: Local vs Global.
- When to use which kind of partitioned index.
- Reducing contention with Hash partitioning.
- 12c New Features:.
- Online partition move.
- Partial indexing.
Who should attend
- Database Administrators
- Architect
- Project Manager
Prerequisites
- Prior knowledge of partitioning is not required
Course Objectives
- Learn to use the most important and most efficient techniques related to partitioning
Course Content
- Partition Pruning
- Rolling Window
- Interval partitioning
- Compressed Partitions
- Exchange Partition
- Partitioned Indexes: Local vs Global