Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
Description
Add a variable like
optimizer_convert_like_to ft
with default = 0.
If set to 1
set optimizer_convert_like_to ft = 1
1.
Analyze, if query have conditions, which likely cause a full scan
like
tag LIKE '%aaaa%' OR LIKE '%bbbb%' |
2
Check, if the column has a full text index.
If 1. + 2. true ,
the query use full text index like "match against" syntax.
This can improve application, where changing the queries is difficult like snow
Attachments
Issue Links
- relates to
-
MXS-5297 add smart rewrite function from "%like%" to "match against"
- Open