Re: fast table scan

trying to enlarge db_file_multiblock_read_count. It may take less IO.

Please email me back what the difference you find.

Thanks

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

Received on Thu Apr 15 1999 - 15:54:32 CDT