|
Index, Cluster (described later) - are optional structures associated with tables, which can be created to increase the performance of data retrieval
|
|
Indices are created on one or more columns of a table. An Oracle index provides a faster access path to efficiently locate requested rows
|
Create an index in Oracle - An Example
-
We knew that Last name may be the most frequently used column in query.
-
An index on this column would improve most queries using this field, in particular when there are many rows in the person_info_table and most of them have distinct values on this column
-
CREATE INDEX last_name_index ON person_info_table(last_name);
|
