Re: Full tablescans explain plans and indexes

Thiko! wrote:
> Hi
>
> Im trying to eliminiate full tablescans from 'top' sql querries on our
> database system. I was led to believe that full table scans on very
> large tables was a big 'nono'.

This is incorrect. Often they are the optimal solution.

My suggestion ... purchase Tom Kyte's books, sit back, and enjoy a good read.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)