Pro Oracle Database 23c 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 23c Administrationhttps://doi.org/10.1007/978-1-4842-9899-2_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 having to retrieve all of data columns of a table. This can help 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 you are locating information in a book, ...