Star Transformation Questions
Now that we've seen the various star schema explain plans and their performance results, let's examine star transformation in a little more detail. Over the past few years, when presenting and speaking on data warehouses, I've been asked quite a few questions regarding star transformation queries. Often I find it's really just a matter of getting comfortable with these radically different concepts for handling large fact tables. Here are some of the most frequently asked questions:
Q: Does the Oracle version matter?
Yes. As I've said numerous times up to this point, you must use Oracle 8i or 9i for best results, although Oracle 8.0 introduced many of the necessary features and may well work for small to mid-sized ...
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.
