3 ms·
Well, in my experience full table scans are quite rare. What happens often though is an index scan, but those happen so often that you would get a ton of false
by yread 17y ago
Well, in my experience full table scans are quite rare. What happens often though is an index scan, but those happen so often that you would get a ton of false positives.
Plus, at least in my company, the unit tests run on a different database which means different statistics, different number of rows and different decisions in the query optimizer.