Understanding 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 MoreMost Popular Databases
Understanding 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 MoreAbout Oracle 11g Deduplication
Oracle deduplication can the amount of storage space needed for LOBs, which can provide significant cost savings for storage.
Read MoreAbout Oracle 11gR2 RAC One Node and RAC Patching
Oracle RAC One Node represents an Oracle RAC database that runs only one active Oracle database and can be managed using Server Control Utility (SVRCTL) as any Oracle RAC database.
Read MoreAbout Ready-Only Tables in Oracle 11g
Oracle Database 11g now allows you to make a single table read-only without affecting the other tables in the tablespace, and change it back to read-write to allow inserts and updates when needed.
Read MoreAbout Oracle 11g REF Partitioning
Oracle 11g REF partitioning enables partitioning a table based on the foreign key parent-child relationship; in this case, the partitioning key of the child table is inherited from the parent table.
Read MoreAbout Oracle 11gR2 Automatic SQL Tuning
Oracle 11g runs the SQL Tuning Advisor against SQL statements determined to be of high impact based on statistics from the Automatic Workload Repository (AWR).
Read MoreAbout Oracle 11gR2 Advanced Compression
Oracle 11g Advanced Compression offers the promise of tables that take up less space, and lower cost for disk storage for databases. Learn more.
Read More