>
> 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.
Received on Sun Jun 11 2000 - 16:05:24 CDT
