Reg Expr searches is really slow!

[CapsuleCorpJX]

For example, if this was in the where clause:

TRIM(DATABASENAME) like 'test\_db\__mine' ESCAPE '\'"

I'd be searching for test_db_<*>mine where <*> is any single character.

What I noticed is that such a filter will significantly slow down a query. Anyone else noticing this? Makes sense though, since there the system must linearly search for matches and mismatches to the expression.

 

[BillDHS]

Unless Datbasename is a varchar field I don't think you need the TRIM function. If that is true removing it should help the speed.