Partitioning – Pitfalls and Positives
This presentation can help you to avoid problems when using Partitioning
The oneliner is : Simple Works Best.
The experience (and some demos) is mainly Oracle based,
but investigating other database-engines as well. There is Real Potential there to improve handling of “Large” Tables.
Partitioning will notably help you to store and “manage” large tables of facts or items.
I expect Partitioning to be or to become an effective tool to store very large, and often volatile sets of data in a “relational” database and I will point out some obvious use-cases.
After the presentation, the attendee will be prepared to use Partitioning, will understand some of the mistakes from the past, will be able to make better design-decisions for large tables, and is better able to achieve success.