Re: METALINK and OWS

I did? Wanna point out exactly WHERE in my message I said that? Jared, you find it and I will buy you a beer at the next conference.

Rachel

>From: Jared Still <jkstill_at_bcbso.com>
>To: Rachel Carmichael <carmichr_at_hotmail.com>
>CC: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: METALINK and OWS
>Date: Mon, 12 Jun 2000 09:02:35 -0700 (PDT)
>
>
>ROFL!
>
>' But Rachel Carmichael said to drop them! '
>
>Jared
>
>On Sun, 11 Jun 2000, Rachel Carmichael wrote:
>
> > WHOA! Slow down before you drop the indexes. Indexes are not totally
> > useless! It very much depends on the queries you run against your
>database.
> > If you are doing a mixture of queries, where some return single rows or
>a
> > very small subset of data, and some return a large number of rows, you
>still
> > should keep the indexes for the first type of query.
> >
> > Rachel
> >
> >
> > >From: Nicholas Tufar <ntufar_at_chemist.gen.tr>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: Re: METALINK and OWS
> > >Date: Sun, 11 Jun 2000 14:17:51 -0800
> > >
> > > >
> > > > Nicholas,
> > > >
> > > > Sorry... I thought most people knew this. Oracle says that if a
>query
> > >will
> > > > return more than 20% of the rows of a table, it will use a full
>table
> > >scan.
> > > > So you DON'T tune it to use an index. In fact, as of 8i, I believe
> > >Oracle
> > > > now recommends that if a query returns as little as 3-5% of a table,
>a
> > >full
> > > > table scan is the way to go.
> > >
> > >A very valuable piece of information. How did I miss it!
> > >Now I know what I am going to do on Monday. I had a feeling that
> > >all those indeces are useless, now I know why they are.
> > >Thank you very much.
> > >
> > >Nicholas
> > >--
> > >Author: Nicholas Tufar
> > > INET: ntufar_at_chemist.gen.tr
> > >
> > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > >San Diego, California -- Public Internet access / Mailing Lists
> > >--------------------------------------------------------------------
> > >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).
> >
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> >
>
>
>Jared Still
>Certified Oracle DBA and Part Time Perl Evangelist ;-)
>Regence BlueCross BlueShield of Oregon
>jkstill_at_bcbso.com - Work - preferred address
>jkstill_at_teleport.com - private
>
>