Lesson 1
Tuning with Oracle8 partitioning
Now that you have an understanding of how to use data blocks, the data dictionary,
and data structures for advanced Oracle8 tuning, you are ready to more closely examine the Oracle partitioning facility.
By the time you complete this module you should be able to:
By the time you complete this module you should be able to:
- Describe how partitioning functions in Oracle
- List the differences between global and local partitioning
- Describe the structure of a partitioned index
- Explain how to load a partition
- Explain how to maintain an indexed partition