-
Hi,
I have been trying to eliminate fragmentation in objects in the database. I noticed that one of my primary keys are fragmented. I just wanted to confirm whether I rebuild them exactly the way I rebuild regular indexes?
Thanks in advance,
Nirasha
-
I guess you can rebuild primary key just like regular indexes.
Reddy,Sam
-
Rebuild the index associated with the primary key. To defarg the segment you should rebuild it with proper storage paramters according to the index size.
-
Hi,
This is Rohit Nirkhe,OCP from India.When u create a primary key Oracle automatically creates an index with the name of the primary key constraint.
U can find out the name of index and other information from dba_indexes and analyze the index.
U can rebuild the index with the following command
ALTER INDEX <indexname> REBUILD;
Any help please write to me at
rohitsn@hotmail.com
-
Starting from 8i, an index on PK is not mandatory.
You can have a PK without index.
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
|