Const
How often a sweep step may run: 25% of 100,000 rows is 1,562 pages a day, so 48 steps of one 50-page batch cover it, at under 10% of free's 5,000,000 daily reads for enumeration.
How often a sweep step may run: 25% of 100,000 rows is 1,562 pages a day, so 48 steps of one 50-page batch cover it, at under 10% of free's 5,000,000 daily reads for enumeration.