Oracle-L: RE: SERACH FAST

From: <Rajesh.Rao_at_jpmchase.com>
Date: Wed, 13 Nov 2002 10:19:35 -0800
Message-ID: <F001.0050268A.20021113101935@fatcity.com>

The best way to make any query run fast is to truncate all tables. ;-)

                                                                                                                    
                    Rachel                                                                                          
                    Carmichael           To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>        
                    <wisernet100@        cc:                                                                        
                    yahoo.com>           Subject:     RE: SERACH FAST                                               
                    Sent by:                                                                                        
                    root_at_fatcity.                                                                                   
                    com                                                                                             
                                                                                                                    
                                                                                                                    
                    November 13,                                                                                    
                    2002 12:49 PM                                                                                   
                    Please                                                                                          
                    respond to                                                                                      
                    ORACLE-L

does this new parameter replace the old _make_sql_run_faster ??

I know in V7 you set that parameter to TRUE or FALSE but in 8i you could set a percentage value

I like the BCHR99% value, think I'll set all my 9i databases to that one

"Fink, Dan" <Dan.Fink_at_mdx.com> wrote:
> Igor,
> That was the 8i syntax, I believe it is changed for 9i to be
more
> flexible:
> _search = FAST|MODERATE|SLOW|BCHR99%
>
> ;)
>
> -----Original Message-----
> Sent: Wednesday, November 13, 2002 9:04 AM
> To: Multiple recipients of list ORACLE-L
>
>
> undocumented parameter:
>
> _search_fast = TRUE :-)
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com
>
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, November 13, 2002 10:38 AM
>
>
> > Hi
> > How to make search fast? We are building some application and this
> > application need to build more efficient fast search.
> > WIth regards
> > -Dinesh
> >
> >
> >
> >
> >
> > _________________________________________________________________
> > Add photos to your messages with MSN 8. Get 2 months FREE*.
> > http://join.msn.com/?page=features/featuredemail
> >
> > --
> > 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: Igor Neyman
> INET: ineyman_at_perceptron.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: Fink, Dan
> INET: Dan.Fink_at_mdx.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).

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: Rachel Carmichael
  INET: wisernet100_at_yahoo.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: 
  INET: Rajesh.Rao_at_jpmchase.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 - 12:19:35 CST