Ask HN: Databases have indexes. Then why have partitions? Posted by matc on Tuesday January 31, 2012 @10:50PM from the ask-hn dept. ( 4 comments | 2 points | on HN )
Because your queries need to be fast, and you can chop up your data into 1000 pieces (by some column or combination) without adding complexity.
Queries can be fast with indexes without adding complexity.