Re: FULL TABLE SCANS...

> .... The bottom line is that if you want more than 20% of a table the
> probably a full table scan is more efficient, there are a number of
> caveats, it depends upon rows per block, degrees of parallism, is the
> data
> you need stored entirely in the index. The time you dont want full
> table
> scans are when just a few rows are needed.

Oracle recomended use INDEX if the amount of selected data less then 10% of totaldata in the table . This is usefull with PUSH_SUBQ hint too. Received on Tue Nov 18 1997 - 00:00:00 CST