A datawarehouse environment is used differently than a transactional environment, so architecture and indexing strategies should also be different. In this presentation, we review what the ultimate goal of an index really is, what the point of a data warehouse is, and how they relate to each other. You will also learn common practices for indexing the different types of warehouse tables, specifically dimension tables, fact tables, and staging tables. We will review cases when it is useful to have summary level fact tables, in addition to detail level fact tables. Then, lastly, we will look at the benefits, and gotchas, of using columnstore indexes.
You can get to the presentation slide-deck by clicking here. There are helpful notes on most of the slides.
The script referenced in the slide deck can be downloaded by clicking here.
Also, there have been a number of requests to be able to get the cute frog pics, so here they are!
This session is also available via a recording, which can be found by clicking here. It was presented to the Data Architecture Virtual PASS chapter (although it has been updated since then, the majority of the presentation is the same).