What is a star schema?
- A Fact tables containing measures surrounded by dimension tables providing context
- B A single flat wide table
- C A circular set of relationships
- D A hierarchy of nested tables
Answer
Fact tables containing measures surrounded by dimension tables providing context
The VertiPaq engine is optimised for this shape. Flat wide tables and snowflakes both perform worse, sometimes dramatically so.





