Speed up full table scan under W95

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Fri, 31 Dec 1999 11:41:16 +0100
Message-ID: <84i19j$p82o$1@fu-berlin.de>

Hello,

I have a table tab1 with the following columns

id NUMBER
startdate DATE
enddate DATE

I want to perform a full scan using

select avg(endtime-starttime) from tab1.

I have 240,000 records in tab1. The thing is, that I have the table both in a PO database under W95 and under MS Access, and they have the same performance on the same machine, which is in my opinion not a surpise because there isn't much to optimize on this statement and the bottleneck is disk I/O.

But how can I make Oracle beat the performance of MS Access? I have 4 disks. Would it be good to make a partition table over the 4 disks (SCSI) as a 'manual striping' ? Would it be faster to increase the blocksize to 8k ? Should I increase the db_file_multiblock_read_count to 32 or more?

I have about 50000 db_block_buffers (2k block size) and I think, the table will fit into memory (256M).

I am thankful for every kind of help or ideas!

Have a happy New Year

Uli Received on Fri Dec 31 1999 - 04:41:16 CST