Chapter 5. Tuning Ad-Hoc Queries
This is the single most important chapter in the entire book. Here I'll explain how to get lightning-fast queries, even though you have no idea what those queries may look like (i.e., truly ad-hoc reports). This is also going to be the hardest chapter for many DBAs to accept because the advice flies so contrary to popular belief. But rest assured, this is the only way to go.
A really good question to ask at this point is: Why am I covering ad-hoc query tuning before other major topics such as loading data? The answer is simple: If end-users cannot quickly view reports on the data, then the data warehouse is a bust. In fact, you can judge your data warehouse's success by simply asking the following: Do the end-users ...
Get Oracle® DBA Guide to Data Warehousing and Star Schemas 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.