An index entry of the Index section of a book points to the location of the word/phrase indicated by the entry. The index entry helps you find the pages containing the word/phrase. Similarly, a column index of a table can speed up your finding data in a database. If your query has a condition on a column (or columns) that is (are) not indexed, the table will be fully scanned and the query will be slower than if an index was available.
This appendix shows you how to create various indexes. The topics covered are as follows.
▪ Creating an index
▪ Multi-column indexes
▪ Bit map and join bit map indexes
▪ Function-based indexes
▪ Deleting an index
To create an index on a column or columns of a table, use ...