Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Improving performance of full table scans

Re: Improving performance of full table scans

From: Bob Jones <email_at_me.not>
Date: Mon, 11 Sep 2006 23:49:24 GMT
Message-ID: <8CmNg.510$GR.498@newssvr29.news.prodigy.net>

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message news:1157978637.985347.258030_at_q16g2000cwq.googlegroups.com...
>
> 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.
>

If this is a correct assumption, then most people don't know what they are doing.

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

Ok, more book recommendations. Received on Mon Sep 11 2006 - 18:49:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US