I have been thinking to write this post for quite sometime. I thought it will be good to share my success story of making a VLDB run super fast. 924 more words
Tags » Partitioning
It’s been long time I’ve written any post and I’ve always been thinking of writing something unique. Finally, I got something :) . Normally, I prefer to write long posts but this time I will try to keep it brief and precise. 1,138 more words
Here’s an example of where the optimizer really should ignore a hint.
I’m testing an implementation of deliberately unusable index partitions – i.e. some empty index partitions, some usable. 133 more words
If the partitioning MERGE command is executed for the wrong range after a SWITCH OUT of historic data, movement between file groups may be necessary before or during the next index rebuild. 1,759 more words