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.