Analyze schema v/s Rebuild Indexes

[dknight]

It is important that the indexes are rebuilt, and in the course, the index on the primary key is rebuilt.

But you don't rebuild the PKs themselves.

This is sort of a namegame.

[ronnie]

Is it correct that whenever a Primary Key is created a corresponding Index is created.

Am I correct when i say this.

[KenEwald]

Yes, an index is created when a primary key is created or enabled.

-Ken

[jmodic]

Index is created together with primary key only if appropriate index is not allready present in the system. If an index that covers PK constrained columns is allready there, PK uses this existing index to inforce the constraint. And in this case index does not need to be created as an unique index.

[KenEwald]

True.