RE: METALINK and OWS

Really, a very valuable piece of information.

Thank you Rachael and Thank you Nicholas for asking Rachael this clarification.

Maheshwara Rao, L., Teki
E Mail : teki01_at_mediaone.net

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Nicholas Tufar
Sent: Sunday, June 11, 2000 6:18 PM
To: Multiple recipients of list ORACLE-L Subject: Re: METALINK and OWS

>
> 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).