Introduction to Oracle Indexes to manage Database Objects
There is more to a database than simply storing data. Databases are useful because people can retrieve the data that is stored.
The faster they can retrieve the data, the more useful the database becomes.
Indexes are structures that improve the performance of data retrieval. Indexes also serve other purposes, such as guaranteeing that
data entered is unique, but their primary purpose is to retrieve meaningful data from the database more quickly.
This module covers the use and management of indexes.
The use of indexes can significantly improve the performance of your database. Understanding the hows and whys of indexes will improve your
abilities as a database administrator.
In this module, you will learn:
Why indexes are used
The basic types of indexes
How to create an index
Storage considerations for indexes
How to alter an index
How and why to rebuild an index
How to find out about indexes from the data dictionary
How to drop an index