2 ms·
I don't know if it's meaningful to call the query a table scan when the database engine intelligently guesses that it's faster to scan the table than run throug
by kevingadd 17y ago
I don't know if it's meaningful to call the query a table scan when the database engine intelligently guesses that it's faster to scan the table than run through the index. Usually when you're talking about table scans in the context of optimization, it's queries that must be a table scan, no?
I'm sure there are lots of cases where the database engine's heuristics can be wrong, or an index-based scan is less efficient than a full table scan, but the source article isn't explicitly talking about any of those cases.