Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: fast table scan
You can alter table:
SQL> alter table <TABLE_NAME> cache;
this will keep it in the db_buffers
+--------------------------------------------------------------------------+ | Vitaliy Mogilevskiy | Senior Consultant | CORE Technology Group, Inc. | E-mail: vit100gain_at_earthlink.net | Web Page: http://home.earthlink.net/~vit100gain/index.html | *** Free DBA Script Library at my Web Page *** +--------------------------------------------------------------------------+
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 - 17:18:34 CDT