Originally posted by marist89
All that good stuff being said, a table of 14 million rows wouldn't ring my bell for partitioning. 140 million, maybe.
It might do if every query selected about 10% of table rows and there was a potential partitioning scheme that allowed partition scans instead of table scans. But it's all hypothetical.