MMartin1 (11/25/2015)
As mentioned in the blog, in a DW with over 100 Million rows , most of the queries will end up performing scans
I dont know what qualifies as "most queries." One does not know others beyond ones own. If I only need to sum a date range, and not the whole table, how can a simple index not help? Most of the queries I see are sliced and diced, and it takes only one query to give a sum of all rows.
Funny enough - I'm working right now on a DW with one of the tables containing 105 million rows.
If a single query within numbers of procedures we and online customers run against this table every day would perform a single scan we would be most likely out of business.
:hehe:
_____________
Code for TallyGenerator