Table and index partitioning not only improves query performance but tremendously improves
the manageability of tables in a VLDB environment by allowing you to perform maintenance
operations on one partition while users may be accessing other partitions of the table. We will
cover all the different types of partitioning schemes, including some of the new partitioning features
in Oracle 10g: hash-partitioned global indexes, list-partitioned IOTs, and LOB support in all types
of partitioned IOTs. Oracle 11g brings even more partitioning options to the table: composite listhash,
list-list, list-range, and range-range. Other new partitioning schemes in Oracle Database 11g
include automated interval partitioning, reference partitioning, application-controlled partitioning,
and virtual column partitioning.
Bitmap indexes, available since Oracle 7.3, provide query benefits not only for tables with
columns of low cardinality, but also for special indexes called bitmap join indexes that pre-join
two or more tables on one or more columns. Oracle 10g removes one of the remaining obstacles
for using bitmap indexes in a heavy, single-row insert, update, or delete environment: mitigating
performance problems due to bitmap index fragmentation issues.
Oracle Data Pump, new to Oracle 10g, picks up where the traditional import and export
functions leave off. One of many features supported by Oracle Data Pump performs export
directly to another instance; in addition, most Data Pump operations occur on the server side
instead of the client side.
Pages:
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815