In this tip, I show how and why a columnstore index can provide benefits to COUNT(*) queries.