Re: CONTAINS,CATSEARCH, andMATCHES are more effective than plsql equivalent?

From: <Jared.Still_at_radisys.com>
Date: Wed, 5 May 2004 10:44:10 -0700
Message-ID: <OF3FA1BC3A.E26F0424-ON88256E8B.0061510E-88256E8B.006169C7@radisys.com>

I don't believe there are any equivalent PL/SQL functions, unless you write your own.
PL/SQL won't be able to compete with Oracle Media ( is that its name this month?) in terms of performance.

Jared

"Juan Cachito Reyes Pacheco" <jreyes_at_dazasoftware.com> Sent by: oracle-l-bounce_at_freelists.org
05/05/2004 07:11 AM
Please respond to oracle-l

        To:     <oracle-l_at_freelists.org>
        cc: 
        Subject:        CONTAINS,CATSEARCH, andMATCHES are more effective than plsql equivalent?

If you have installed Oracle text you can use other functions like CONTAINS,CATSEARCH, andMATCHES

My question is if someone knows about some performance test that shows Oracle text functions as better than plsql equivalent functions.

Thanks

Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Wed May 05 2004 - 12:41:24 CDT