Pro Oracle Database 23ai Administration: Manage and Safeguard Your Organization’s Data

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2024

M. Malcher, D. KuhnPro Oracle Database 23ai Administrationhttps://doi.org/10.1007/979-8-8688-1038-1_8

8. Indexes

Michelle Malcher¹   and Darl Kuhn²

(1)

Huntley, IL, USA

(2)

Morrison, CO, USA

 

An index is an optionally created database object used primarily to increase query performance. Indexes can also limit the amount of data that is returned in the results without retrieving all a table’s data columns. This can keep results in-memory and bring back results faster. The purpose of a database index is similar to that of an index in the back of a book. A book index associates a topic with a page number. When locating information in a book, it is usually much faster ...