CHAPTER 8
Dynamic Sampling and Cardinality Feedback
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 ...
Get Oracle SQL Tuning with Oracle SQLTXPLAIN now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
