When to partition ?
When not to partition ?
Choosing right partitioning key
Choosing right partitioning strategy
How to convert existing table to partitioned table in a critical environment
Rollback strategy
Many more tips and tricks (MUST WATCH VIDEO ON PARTITIONING !!)