Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale
Table partitioning is a blessing in that it makes large tables that have varying access patterns more scalable and manageable, but it is a mixed blessing. It is important to understand the down-side before using table partitioning.
2012-11-08
4,482 reads