How to Choose a Database Index
#3 Data Warehouse December- clustered vs non-clustered indexes
Two weeks ago we compared optimizing our data warehouse to the organization of a grocery store. The goal of each is to help us find what we need, quickly.
The process of data pruning is similar to scanning the aisles to narrow down our search for pickles, or tomato sauce. Indexing is one of the tools in our tool belt to help prune our data, speeding ove…
Keep reading with a 7-day free trial
Subscribe to Learn Analytics Engineering to keep reading this post and get 7 days of free access to the full post archives.