Abstract
An execution plan, as described in Chapter 6, is composed of several operations. The most commonly used operations are those that access, filter, and transform data. This chapter specifically deals with data access operations, or, in other words, how the database engine is able to access data. There are basically only two ways to locate data in a table. The first is to scan the whole table. The second is to do a lookup based on a redundant access structure (for example, an index) or on the structure of the table itself (for example, a hash cluster). In addition, in the case of partitioning, access might be restricted to a subset of partitions. This is no different from looking up specific information in this book. Either you read the whole book, you read a single chapter, or you use the index or table of contents to find out where the information you are looking is.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2008 Christian Antognini
About this chapter
Cite this chapter
(2008). Optimizing Data Access. In: Troubleshooting Oracle Performance. Apress. https://doi.org/10.1007/978-1-4302-0498-5_9
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0498-5_9
Publisher Name: Apress
Print ISBN: 978-1-59059-917-4
Online ISBN: 978-1-4302-0498-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books