Re: fast table scan

From: <tienlee_at_mailexcite.com>
Date: Mon, 19 Apr 1999 17:25:57 GMT
Message-ID: <7ffouo$kvt$1@nnrp1.dejanews.com>

Increase db_file_multiblock_read_count, cache the table and also recreate the table to be on db_buffers_pool_keep so that your subsequential SQL might be faster.

Good luck.

In article <7f0atu$lq5$1_at_nnrp1.dejanews.com>, rosmit_at_acxiom.com wrote:
> I am looking for the fastest possible way to scan a table. The table is
> small - 10,000 rows with a datafile of about 1.5MB. I want to run a query
> (or have ProC fetch) in .020 seconds or less.
>
> The query has no where clause or order by clause. There is no index. My best
> timing so far is .463 seconds to fetch from a newly started instance - had to
> parse, read datafile, return data). After it was cached, it took .068 to
> re-fetch it.
>
> Any idea how I can accomplish this?
>
> Can you turn the caching overhead off in Oracle - some sort of direct path
> select?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 19 1999 - 12:25:57 CDT