| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SERACH FAST
Seema - Just searching by scanning with a query like WHERE TEXT LIKE
'%SOMETHING%' is very slow.
To search for text within columns, the Intermedia suggestion from Raj is
probably the best solution. If you just need to search just a few columns
for specific terms, then you could consider a function-based index. I don't
know the cost for Intermedia, but you can build your own equivalent by
pulling the data out and indexing it, then storing the indexes within
Oracle. Your program can search using your indexes, which will point to the
actual record.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, November 13, 2002 11:16 AM
To: Multiple recipients of list ORACLE-L
Hi,
>Seema - Can you be more specific about what you are searching for? Column
>data?
:soME CASES YES
Can you index it?
:Yes I did.
Text within columns?
:yes
Thx
-Seema
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: oracledbam_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Nov 13 2002 - 11:43:55 CST
 |
 |