title: snowflake is better than indexing?
body: <p>Here is the problem, I have a sales information table which contains sales information, which has columns like (Primary Key ID, Product Name, Product ID, Store Name, Store ID, Sales Date). I want to do analysis like drill up and drill down on store/product/sales date.</p>
  
  <p>There are two design options I am thinking about,</p>
  
  <ol>
  <li>Create individual index on columns like product name, product ID, Store Name, Store ID, Sales Date;</li>
  <li>Using data warehouse snowflake model, treating current sales information table as fact table, and create product, store, and sales date dimension table.</li>
  </ol>
  
  <p>In order to have better analysis performance, I heard snowflake model is better. But why it is better than index on related columns from database design perspective?</p>
  
  <p>thanks in advance,
  Lin</p>