Re: Index on Primary Key

The default behavior of Oracle is to index the primary key IF A MATCHING INDEX DOES NOT ALREADY EXIST. As long as a primary key is enabled, there is a corresponding index. If the primary key is disabled or dropped, the corresponding index is dropped IF IT WAS CREATED AUTOMATICALLY BY ORACLE WHEN THE PK WAS CREATED. If the index was defined independently prior to the creation of the PK, the index will remain when the PK is dropped.

As a side question, why wouldn't you want an index on a primary key???

Rich

In article <OghHU8Aj#GA.295_at_ntawwabp.compuserve.com>,   "Snow Tracks" <snowtracks_at_compuserve.com> wrote:
> If I use ERwin to build an Oracle schema, its default behavior is to index
> the primary key.
>
> Any have any thoughts/experience with an index on the primary key?
>
> Thank you,
> st
>
>

--

Rich Goldkamp, Consultant, OCP		RJGoldka_at_dcss.com
Digital Consulting & Software Services	(504) 523-5005 x2736

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own