U can use Oracle intermedia/"Oracle Text"/Ultra search. what kind of data Ur performing this search on. What is the datatype of the data? How exactly U r trying to search right now?
U need to gather all this information? OraCop --- Seema Singh <[EMAIL PROTECTED]> wrote: > Oracle 8.1.6, > > > > > > > >From: OraCop <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > >Subject: Re: SERACH FAST > >Date: Wed, 13 Nov 2002 08:15:19 -0800 > > > >Seema Ji, > > Are U using "Oracle Search" for this purpose? > > Are u using search indexes and using them > >correctly? > > What version of Oracle? > > > > Regards. > > > >OraCop > > > > > >--- Seema Singh <[EMAIL PROTECTED]> wrote: > > > Hi > > > How to make search fast? We are building some > > > application and this > > > application need to build more efficient fast > > > search. > > > WIth regards > > > -Seema > > > > > > > > > > > > > > > > > > > >_________________________________________________________________ > > > Protect your PC - get McAfee.com VirusScan > Online > > > > >http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Seema Singh > > > INET: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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). > > > > > >__________________________________________________ > >Do you Yahoo!? > >U2 on LAUNCH - Exclusive greatest hits videos > >http://launch.yahoo.com/u2 > >-- > >Please see the official ORACLE-L FAQ: > http://www.orafaq.com > >-- > >Author: OraCop > > INET: [EMAIL PROTECTED] > > > >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: [EMAIL PROTECTED] (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). > > > _________________________________________________________________ > The new MSN 8: advanced junk mail protection and 2 > months FREE* > http://join.msn.com/?page=features/junkmail > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Seema Singh > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __________________________________________________ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).