Skip to main content

Dynamic Sampling and Cardinality Feedback

  • Chapter
Oracle SQL Tuning with Oracle SQLTXPLAIN
  • 706 Accesses

Abstract

Imagine you’ve been given the job of sorting through some books in a house to find all the references to the word “Vienna” in the book titles. You’ve been told there are 2 or 3 books in the study, and that there is an index in the desk if you need it. Naturally with 2 or 3 books or even a dozen books, there’s no point in using the index in the desk, you’ll just look at the book titles one by one and quickly find all of the books with “Vienna” in the title. Unfortunately, what you didn’t know is that since the last person looked at the books the owner has bought the entire contents of the local public library, but you only discover this after you start. It’s going to be a long day if you stick to your plan.

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 34.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2013 Stelios Charalambides

About this chapter

Cite this chapter

Charalambides, S. (2013). Dynamic Sampling and Cardinality Feedback. In: Oracle SQL Tuning with Oracle SQLTXPLAIN. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4810-1_8

Download citation

Publish with us

Policies and ethics