New answers tagged


A single "fat" table will be more efficient than joining 10 separate tables. While the disk IO will be the same in principle, a view will need to perform 9 joins - essentially 9 large sort/merge operations. Materialized views ( makes it easy to separate the physical layout of the '...

Top 50 recent answers are included