Reduce disk IOs by 99% with this simple trick

Hey, there!

Often we can achieve great tuning success by decoding the problem and then rewriting the queries. This can, of course, be more costly than a purely technical optimization in which we consider the problem as a black box, but can be very lucrative, like in our example (saving 99% IOs):

Recursion vs. Period Data Datatype

Enjoy reading,

Roland - DWHPro