Re: Why INDEX SCAN instead of FULL SCAN?
From: Daniel V. Pedersen <daniel_at_rtfm.dk>
Date: Wed, 30 Oct 2002 09:58:30 GMT
Message-ID: <slrnarvba5.2p50.daniel_at_styx.kummefryser.dk>
Date: Wed, 30 Oct 2002 09:58:30 GMT
Message-ID: <slrnarvba5.2p50.daniel_at_styx.kummefryser.dk>
In article <6c30a166.0210292251.5e0ddbd9_at_posting.google.com>, Sara wrote:
> I'm trying to understand why, when there are no
> indexes and no other constraints except primary
> keys, why Oracle does an INDEX UNIQUE SCAN on
> one of table involved in a simple equijoin.
Primary key + unique automagically brings with them an index.
-- Daniel Villfrance Pedersen Nøgenhed til folket!Received on Wed Oct 30 2002 - 10:58:30 CET