Any suggestion for speeding up a query that uses REGEX LIKE

Question

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 `SUBSTR foo = bar` I still see the query taking more than 10 seconds

Mayank · Answer

Have you tried text index

Mayank · Answer

Aaron Wishnick · Answer

Does it play nice with star tree index

Aaron Wishnick · Answer

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

Mayank · Answer

Should work

Aaron Wishnick · Answer

Ok that s really neat

Aaron Wishnick · Answer

How can a text index accelerate a regex to be faster than table scan

Mayank · Answer

It leverages lucene index internally

Aaron Wishnick · Answer

Cool