-
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.
David Knight
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.
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
Yes, an index is created when a primary key is created or enabled.
-Ken
-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|