Re: Performance of REGEXP_LIKE vs LIKE?

From: Thomas Kellerer <JUAXQOSZFGQQ_at_spammotel.com>
Date: Fri, 20 Apr 2007 08:53:47 +0200
Message-ID: <58r6brF2gjvo1U1@mid.individual.net>

On 20.04.2007 08:52 Rene Nyffenegger wrote:

> On 2007-04-19, Thomas Kellerer <JUAXQOSZFGQQ_at_spammotel.com> wrote:

>> On 18.04.2007 22:52 zstringer999_at_gmail.com wrote:

>>> The regular expression syntax is cleaner, especially when you have a
>>> lot of strings to search for!  However, the LIKE expression runs in 20
>>> seconds, while the REGEXP_LIKE one runs in 60 seconds.  Has anyone
>>> else noticed this?  Any way to speed it up?
>>>

>> I thought you should be able to create a function based index to support
>> the regex match but I'm not sure (could have been Postgres where I did
>> that the last time ;) )

>
> You can't, at least on 10g XE:

OK, then it was indeed with PostgreSQL ;) Thanks for the clarification

Regards
Thomas Received on Fri Apr 20 2007 - 01:53:47 CDT