Tag: Wide Tables

Wide tables are usually a standard component of the BI system. Many BI projects will first prepare wide tables at the beginning of construction. A wide table is formed by joining up multiple tables that have a certain association relationship. The result set does not conform to the normal forms; and there is a large amount of redundant data. Moreover, as wide tables need to be pre-created, they are not so flexible to use. But why do people very much prefer wide tables even if they have many shortcomings? Because wide tables are FAST! Querying data in the wide table