Previous Topic Next topic Print topic


Managing Indexes

An index is a data structure that speeds retrieval or enforces certain constraints, such as uniqueness, on the records in a table. This data structure is separate from the table and can be deleted and recreated without affecting table data. There are three types of indexes:

Previous Topic Next topic Print topic