Difference
between Star Schema and Snowflake Schema
Star
Schema
|
Snowflake
Schema
|
De-Normalized
Data Structure
|
Normalized
Data Structure
|
Category
wise Single Dimension Table
|
Dimension
table split into many pieces
|
More
data dependency and redundancy
|
less
data dependency and No redundancy
|
No
need to use complicated join
|
Complicated
Join
|
Query
Results Faster
|
Some
delay in Query Processing
|
No
Parent Table
|
It May
contain Parent Table
|
Simple
DB Structure
|
Complicated DB Structure |
