Putting an index on column where table is partitioned

From: Jesus M. Salvo Jr. <john_at_softgame.com.au>
Date: Tue, 05 Feb 2002 05:32:46 GMT
Message-ID: <28K78.36840$Ni2.210592@news-server.bigpond.net.au>

I have a partitioned table that is partitioned on a DATE column, one partition for each year.

If I dont put an index on that DATE column, and I have a query like "WHERE datecolumn = dateVar", Oracle will automatically know which partition to select from.

If I put an index on that DATE column, wouldn't it make the query slower? .... since it would then have to access the parititioned table by its ROWID as suggested by the ... and therefore would make Oracle scan all paritions.

Is this right? At least this is what I can see from EXPLAIN PLAN ( unless I have misinterpreted it ). Received on Mon Feb 04 2002 - 23:32:46 CST