Figure 5:
On our platform, table scan gives better performance than nonclustered indexed access when the query accesses more than 0.8 percent of the rows in the table.
Back to Article