At Kscope this year, I attended a half day in-depth session entitled Data Warehousing Performance Best Practices, given by Maria Colgan of Oracle. My impression, which was confirmed by folks in the Oracle world, is that she knows her way around the Oracle optimizer.
See part 1 for the introduction and talking about
power and hardware. This part will go over the 2nd “P”,
partitioning. Learning about Oracle’s partitioning has gotten me
more interested in how MySQL’s partitioning works, and I do hope
that MySQL partitioning will develop to the level that Oracle
partitioning does, because Oracle’s partitioning looks very nice
(then again, that’s why it costs so much I guess).
Partition – …[Read more]