Menu Request Demo

Performance Trade-Offs – Joins vs. Storage

17 March 2010

WhereScape's Chuck Kelley has written a blog for BeyeNETWORK on the performance trade offs between joins and storage. 

The question he asks is:

What is the best performing way to load a fact table that has 20 different dimensions?

As he sees it, there are 3 options:

  1. Create the table from a single FROM … WHERE clause
  2. Create a view that does the FROM … WHERE clause and join that to the input for the fact table
  3. Create the table with multiple staging steps joining

The full blog is available at


Comments 0

Leave a Comment

No comments.