I understand how it works, but the book I'm studying doesn't tell me why you'd want to partition. Could someone shed some light? I can't understand any concept unless I see how it's useful.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Jan 26 '12 at 21:17
This question came from our site for professional and enthusiast programmers.
Basically, to split up a huge table into smaller sub tables or partitions
We're talking 100s of millions of rows and/or high volumes.
You don't partition for a few million rows.