Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: fast table scan
Rosmit,
The cache will give you the most return on performance. You could however look at the storage parameters, to make sure you don't waste space in the blocks (pctfree, pctused). Also I would run a trace on the select clause, just to see where the performance problem is. Might be worth checking the execution, are you binding the query ?
So alter table to cache, run a trace/tkprof, check storage parms, binding.
Chris.
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 Tue Apr 13 1999 - 18:03:00 CDT