Re: Improving performance of full table scans

From: <bdbafh_at_gmail.com>
Date: 12 Sep 2006 12:08:46 -0700
Message-ID: <1158088126.579306.59270@e63g2000cwd.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

Here is an article that may be of some help to you:

http://www.evdbt.com/FTS.doc

In order for people to (possibly) supply more detailed information, you MUST supply additional information, such as:

Oracle database server version, edition, major patchset Operating system version, 32 or 64 bit
Processor(s)
Storage hardware configuration, including stripe size db_block_size, tablespace block size for the tablespaces of interest db_file_multiblock_read_count

-bdbafh Received on Tue Sep 12 2006 - 14:08:46 CDT