Re: Improving performance of full table scans

anish wrote:
> Hi all,
>
> Can anyone help me in the ways for imporving the performance of full
> table scans without additional hardware.
>
> Anish
>

You could always increase the size of your database's cache structures. Increasing the buffer cache might help, but there is still a risk of the table aging out of the cache. If the table is not terribly large, then you might want to consider the KEEP cache instead. This all assumes you have enough memory to devote to the SGA. Lack of sufficient physical RAM   will be cause to procure more hardware (memory).

Another thing to consider is to spread your I/O among multiple disk spindles, provided you have them. Make sure you do not have any I/O hotspots on disk.

Otherwise, faster disk and more of them is a way to decrease your I/O times.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown