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

  • From: Jared.Still@xxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 5 May 2004 10:44:10 -0700

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@xxxxxxxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
 05/05/2004 07:11 AM
 Please respond to oracle-l

 
        To:     <oracle-l@xxxxxxxxxxxxx>
        cc: 
        Subject:        CONTAINS,CATSEARCH, andMATCHES are more effective than 
plsql equivalent?


Hi

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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------




----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: