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

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Wed, 5 May 2004 15:06:11 -0400
Message-ID: <011c01c432d4$0c5e03c0$2501a8c0@dazasoftware.com>

>From Tom Kyte

Hi Tom I was reading your book expert one on one and have some performance questions, please

1.under same circumstances is the same to use common plsql like LIKE, where column like 'hola%' or is better to use intermedia in a column used frequently
for like statement.

2. Intermedia is suggested to use only when you have advanced searchs like '%aaa%'?

3. Something more about intermedia performances or advantages about using it,
and when use it, in circumstances when you can use instr, like, etc..

Thanks

Followup:

if you are looking for a WORD in a big string, text indexes would probably be the way to do.

If you are looking for a string that starts with something and ends with anything else, like is just fine. It is when the LIKE string would start with
'%...' that you want to look to a text index.

2) 'only' is far too string. it works well in that case, yes. If aaa was a WORD. 3) Oracle text is an indexing technique. instr, like, etc -- might be able to
use an index, might not. depends.

If you have documents (large text, words in strings) And you want to search them
Text is the right answer.

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
-----------------------------------------------------------------

Received on Wed May 05 2004 - 14:07:46 CDT