O'Reilly logo

Oracle® DBA Guide to Data Warehousing and Star Schemas by Bert Scalzo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required