Optimize REGEXP
Posted by:
Hor Kol
Date: August 05, 2022 05:58AM
I have a table with MEDIUMTEXT field.
Table has 2500 records.
This query takes about 26 seconds to finish:
SELECT myText FROM myTable
WHERE myText REGEXP "\\w*heart\\w*";
Every myText field has text which length is about 50.000 characters (about 6 pages of text).
How to optimize this query?
Subject
Written By
Posted
Optimize REGEXP
August 05, 2022 05:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.