Any suggestion for speeding up a query that uses REGEX_LIKE to filter on a dimension? I see string operations being super slow. Even if I rewrite my regex as
(To be more precise, I want my query to be accelerated by the use of the star tree index, and I also want to quickly filter by regex for one of the dimensions)
m
Mayank
06/18/2021, 9:00 PM
Should work
a
Aaron Wishnick
06/18/2021, 9:02 PM
Ok, that's really neat
How can a text index accelerate a regex to be faster than table scan?