Index

From Oracle FAQ
Jump to: navigation, search

An index is a special database object that lets you quickly locate particular records based on key column values. Indexes are essential for good database performance.

The index creation process requires a temporary segment if the data cannot be sorted in memory. Indexes can be created with the nologging option.

[edit] Creating indexes

Normal indexes:

CREATE INDEX emp_ind1 ON emp(deptno);

Normal composite indexes:

CREATE INDEX emp_ind1 ON emp(empto, deptno);

Bitmap index:

CREATE BITMAP INDEX emp_ind2 ON bigemp(sex);

Function-based indexes (query rewrite must be enabled):

CREATE INDEX emp_ind3 ON emp(deptno*1.1);
CREATE INDEX emp_ind3 ON emp(deptno DESC);

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #