Re: Improving performance of full table scans

Steve Howard wrote:
> hpuxrac wrote:
> > anish wrote:
> > > Hi all,
> > >
> > > Can anyone help me in the ways for imporving the performance of full
> > > table scans without additional hardware.
> > >
> > > Anish
> >
> > Most people want to eliminate full table scans not improve the
> > performance of them.
> >
> > I would recommend Guy Harrison's "Oracle SQL High Performance Tuning"
> > as well as Cary Millsap's "Optimizing Oracle Performance" as books that
> > might be worth reading.
>
> Most do, but not always. We have a warehouse where almost all of our
> queries involve full table scans. Improving their performance is a
> highly valuable tuning technique in that case.

Consider this:
http://oraclesponge.wordpress.com/2006/08/14/more-on-redundant-materialized-views/#comments

jg

-- 
@home.com is bogus.
http://totallyabsurd.com/absurd.htm