About Interval Partitioning in Oracle 11gR2
Oracle 11g interval partitioning extends the functionality of range partitioning so you can define equal-sized (future) partitions using an interval definition.
Read MoreMost Popular
Avoiding Oracle Disk Contention by Using Partitions
Partitioning can increase performance related to large tables in Oracle. Learn how by considering several examples.
Read MoreOracle ASM and Database Deployment Best Practices
Learn about best pracitces for Oracle Automatic Storage Manager (ASM) to improve performance and/or increase availability.
Read MoreWhy Use Oracle Bigfile Tablespaces?
When implemented with Oracle Managed Files or Automatic Storage Management (ASM), Oracle bigfile tablespaces can improve database performance and simplify management of the storage system.
Read MoreAvoiding I/O Disk Contention in Oracle 11gR2
Disk contention occurs when multiple processes try to access the same physical disk simultaneously. Learn how to avoid disk contention.
Read MoreRebuilding Oracle 11g Indexes Online
In Oracle 11g, rebuilding indexes online is much faster, and now is also faster than a DROP and CREATE index. Learn more.
Read MoreUnderstanding Partitioned Indexes in Oracle 11g
A partitioned index in Oracle 11g is an index broken into multiple pieces, adding many possibilities to improve performance and increase maintainability.
Read MoreUnderstanding Hash Indexes in Oracle 11g
Using the Oracle hash index for an exact match in a WHERE clause enables Oracle to access the data by performing one hash function and one I/O instead of multiple I/Os.
Read MoreImpact of Clustering Factor on SQL Statements in Oracle 11g
The clustering factor In Oracle 11g is a measure of the ordered-ness of an index in comparison to the table that it is based on, and can impact database performance.
Read MoreUsing LIKE to Suppress an Index in Oracle 11gR2
LIKE, in some cases, uses an index, while in others, it does not. Learn how this can impact Oracle database performance.
Read MoreConcatenated Indexes in Oracle 11gR2
When a single index in Oracle has multiple columns that are indexed, it is called a concatenated or composite index; however, you should be careful when selecting the order of the columns in the index.
Read MoreInvisible Indexes in Oracle 11gR2
Oracle 11gR2 allows you to turn off the index (make it invisible), yet continue to maintain the index (during any DML—INSERT/UPDATE/DELETE) in case you need to turn it back on quickly.
Read More