fast table scan

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 Tue Apr 13 1999 - 15:54:25 CDT