Home
Home
Help
Help
Contact us
Contact Us

Oracle Database Search Results: indexing within Performance Tuning Guide

This book Oracle Database 11g Release 2 (11.2) documentation
All of Oracle.com

Results 1 to 10 of about 215 for indexing.

Topic Types
Emphasize concepts
Emphasize tasks
Emphasize examples
Job Roles
Emphasize administration topics
Task Appending Columns to an Index or Using Index-Organized Tables
One of the easiest ways to speed up a query is to reduce the number of logical I/Os by eliminating a table access from the execution plan.
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Chapter Using Indexes and Clusters
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Task Using Function-based Indexes for Performance
A function-based index includes columns that are either transformed by a function, such as the UPPER function, or included in an expression, such as col1 + col2.
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Task Using Partitioned Indexes for Performance
Similar to partitioned tables, partitioned indexes improve manageability, availability, performance, and scalability.
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Task Using Index-Organized Tables for Performance
An index-organized table differs from an ordinary table in that the data for the table is held in its associated index.
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Task Using Bitmap Indexes for Performance
Bitmap indexes can substantially improve performance of queries that have all of the following characteristics:
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Task Using Bitmap Join Indexes for Performance
In addition to a bitmap index on a single table, you can create a bitmap join index, which is a bitmap index for the join of two or more tables.
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Task Using Domain Indexes for Performance
Domain indexes are built using the indexing logic supplied by a user-defined indextype.
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Task Using Nonunique Indexes to Enforce Uniqueness
You can use an existing nonunique index on a table to enforce uniqueness, either for UNIQUE constraints or the unique aspect of a PRIMARY KEY constraint.
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Task Using a Different Index Type
There are several index types available, and each index has benefits for certain situations.
Performance Tuning GuideSearch this bookHide this bookContentsPDF

Result page: 1 2  3  4  5  6  7  8  9  10   Next >>