Some Parting Thoughts
As you've read, it's not that hard to obtain star transformation explain plans, and thus, fast ad-hoc report runtimes. But, I still find a lot of people wanting to push for parallel query and partitioning as their “silver bullets” for optimal performance. As I've expressed in this chapter, a non-partitioned and non-parallel query star transformation explain plan will run nearly as fast as a partitioned and parallel queried one. I'm stressing this because far too often, people turn on all the bells and whistles at once and then fail to hit the mark. If you start out with less features turned on and obtain star transformation, then turning on additional features will make things faster, and you will retain nearly identical ...
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.
