I believe it would be faster because indexes and such are maintained per-partition, so you should not get that slowdown as the table size increases (assuming yo

I believe it would be faster because indexes and such are maintained per-partition, so you should not get that slowdown as the table size increases (assuming you are entering data into new partitions.) Additionally, the complexity would be the same as having one big table -- it logically is one big table, the only difference is in your CREATE TABLE statement.