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.
OCP DBA 8i, 9i, 10g
Is it correct that whenever a Primary Key is created a corresponding Index is created.
Am I correct when i say this.
You can if you think you can.
Yes, an index is created when a primary key is created or enabled.
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.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width