Chapter 7's state table already turned a daily refresh into a query that only touches one new day of raw events. That only pays off, in dollars and in speed, if the query planner actually knows it can skip every other day's data — which depends entirely on how the underlying fact table is partitioned and how the query is written against it.
What Partition Pruning Actually Does
A large fact table is typically physically partitioned by date...