Re: Improving performance of full table scans

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 11 Sep 2006 06:14:25 -0700
Message-ID: <1157980465.810777.42570@e3g2000cwe.googlegroups.com>

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.

Regards,

Steve Received on Mon Sep 11 2006 - 08:14:25 CDT