If you're afraid your table has to be read from disk over and over
again, you can do two things:
- specify the CACHE clause for your table. The table blocks will be
put at the MRU-side of the LRU-list and so will be east likely
candidates for removal.
- as from Oracle 8: specify BUFFER_POOL KEEP for your table which will
keep your table blocks in memory.
Jaap.
On Thu, 27 Dec 2001 09:23:19 +0100, Andreas Wizemann
<AWizemann_at_fvvag.de> wrote:
>Hi,
>do i need to define an index on small tables ?
>I'm confused after reading different articles about this.
>One tells me i should define an index the other says there is no need,
>as a full table scan is fast enough.
>Also other articles say, oracle does not read rows in the buffer cache
>while doing a Full table scan. So i think, next time this table will
>be accessed there is another need of doing io.
>So now, whats best ?
>No Index with Full table scan and io's
>or
>Having an Index, so rows may stay in buffer ?
>
>Any Ideas ?
>Thanks a lot.
>
>Andreas Wizemann
- WAS CANCELLED BY =======:
Path: news.sol.net!spool1-nwblwi.newsops.execpc.com!newsfeeds.sol.net!priapus.visi.com!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r
From: j.w.vandijk_at_hetnet.nl (Jaap W. van Dijk)
Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server
Subject: cmsg cancel <3c2f0963.1255440_at_news.freeler.nl>
Control: cancel <3c2f0963.1255440_at_news.freeler.nl>
Date: Mon, 31 Dec 2001 08:01:56 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.3c2f0963.1255440_at_news.freeler.nl>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009788823 26548 166.102.15.34 (31 Dec 2001 08:53:43 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 31 Dec 2001 08:53:43 GMT
X-No-Archive: yes
Comment: Anarchy! Fuck You!
X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1
X-Unacanc3l: yes
This message was cancelled from within Mozilla...not
Received on Sun Dec 30 2001 - 06:38:00 CST