This course is designed for database administrators who will be implementing partitions.
This course is designed for Oracle database administrators.
Upon completion of this course, the participant will be able to:> Decide when to partition and why> Create a portioned table> Create indexes> Utilize the data dictionary
Why Partition?Create A Partitioned TableMore About PartitionsManaging Table PartitionsPartitioned IndexesAbout Equi-PartitioningAbout Query Performance Data Dictionary Information Hash And Composite PartitionsList Partitions
Oracle9i Data Warehouse Administration (RT 270)Oracle9i Parallel SQL Execution (RT 279)
“Every hour of end-user training and IT professional training is worth an average of at least five hours to the enterprise.” (“Untrained Users Cost More to Support than Trained Users”, Gartner, Inc. March 2006)