Does the query optimize a low-cardinality index prefix range search?
You are viewing an old version of this question. View
the current version here.
Different query optimizations and how you can use and tune them to get better performance.
Answer
It can be automatic, if you'll see in the EXPLAIN that "Range checked for each record (index map: N)". But it's pretty expensive operation, so the optimizer doesn't use that often.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
