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!newsfeed.direct.ca!look.ca!newsfeed1.earthlink.net!newsfeed.earthlink.net!uunet!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r
From: Andreas Wizemann <AWizemann_at_fvvag.de>
Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server
Subject: cmsg cancel <haml2ukh1eere5p9mcrp3k8jule26k6hn2_at_4ax.com>
Control: cancel <haml2ukh1eere5p9mcrp3k8jule26k6hn2_at_4ax.com>
Date: Mon, 31 Dec 2001 08:15:28 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.haml2ukh1eere5p9mcrp3k8jule26k6hn2_at_4ax.com>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009789983 28060 166.102.15.34 (31 Dec 2001 09:13:03 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 31 Dec 2001 09:13:03 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 Thu Dec 27 2001 - 02:23:19 CST