Many have wondered, and some have even claimed to know, which data-organization style provides the best performance in a data warehouse. The two schools of thought are, roughly:Denormalize the data into one-big-table (OBT) so that the warehouse never has to do any joins on-the-flyMaintain a star schema that can take advantage of sort keys on the dimension tables
Origem: Star Schema vs. OBT for Data Warehouse Performance | Blog | Fivetran