Re: CONTAINS,CATSEARCH, andMATCHES are more effective than plsql equivalent?
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 5 May 2004 15:06:11 -0400
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:
1) 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@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:
