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

Did I say always?

Would Cary's book not lead you to improving the performance of full table scans? Received on Mon Sep 11 2006 - 11:34:50 CDT