4 ms·
> full table scan, which is appropriate when more than 5% of a table's rows are involved Am I wrong in thinking this ratio could be improved? Table scan being
by hinkley 4y ago
> full table scan, which is appropriate when more than 5% of a table's rows are involved
Am I wrong in thinking this ratio could be improved? Table scan being 20x faster than indexes seems like it might be leaving quite a bit on the table.
- HanyouHottie 4y agoI can believe it. Accessing sequential data that's being prefetched into cache is astonishingly faster than following references.