Skip to main content

Optimizing Data Access

  • Chapter
  • First Online:
Troubleshooting Oracle Performance
  • 798 Accesses

Abstract

An execution plan, as described in Chapter 10, 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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

eBook
USD 16.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 99.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    Actually, there are also multitable hash clusters and index clusters. They’re not described here because they’re rarely used in practice.

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2014 Christian Antognini

About this chapter

Cite this chapter

Antognini, C. (2014). Optimizing Data Access. In: Troubleshooting Oracle Performance. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-5759-2_13

Download citation

Publish with us

Policies and ethics