RelationalDBDesign
RedhatLinuxSys Seomining
prev next prev next
Course navigation
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:
  1. Describe how partitioning functions in Oracle
  2. List the differences between global and local partitioning
  3. Describe the structure of a partitioned index
  4. Explain how to load a partition
  5. Explain how to maintain an indexed partition
The next lesson contains an overview of partitioned objects, how partitions are created, and how we use partitions to improve query performance.
Course navigation