5 ms·
Sometimes SCAN is faster than SEARCH. For example if the query returns a significant percentage of all values.
by yread 4y ago
Sometimes SCAN is faster than SEARCH. For example if the query returns a significant percentage of all values.
- didgetmaster 4y agoI am aware of that, but in this case the query returns less than 5% of the total rows and I think the database should choose to ignore the index if a scan is faster.