Invisible indexes
Youcan remove an index from consideration by the optimizer by making it
invisible??”you know, like a ghost.
Chapter 5: Managing Oracle | 351
Interval partitioning
Gives Oracle Database 11g the ability to create a new partition with a fixed
interval when data to be inserted does not fit in any existing partitions.
Composite partitioning (additional types)
New composite partitioning types include list-range, list-hash, and list-list. Partitioining
can also be based on functions or virtual columns.
Partition pruning
Gives applications the ability to control partition pruning.
Partition Advisor
Gives users an analysis of when partitions could improve performance.
Sequences in PL/SQL
Allows the use of sequences in PL/SQL expressions.
Compound triggers
Youcan now combine triggers with different timing options into a single
compound trigger, which can help improve performance.
Database replay
Captures workloads on production systems and allows you to replay them on
other systems, such as test environments.
Pages:
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755