INDEXES
What is an Index?
- An index is a schema object.
-
Is
used by the Oracle server to speed up the retrieval of rows by using a pointer.
- Can
reduce disk I/O by using a rapid path access method to locate data quickly.
- Is
independent of the table it indexes.
- Is
used and maintained automatically by the Oracle server.
Note: When you
drop a table, corresponding indexes are also dropped.