Why is partitioned view better than partitioned table?

partitioned-tables partitioned-table partitioned-view partitioned-views brent-ozar-unlimited

Post a Reply


Partitioned views can produce even better plans than partitioned tables do for some queries (need to stress “some”). This is purely due to optimizer limitations since the optimizer could break up a partitioned table access into branches, of course. But that’s the way it is.
For More Information Please Refer:

You May Also Like to Read: