Fragmentation in Primary Key

[nirasha]

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

[sreddy]

I guess you can rebuild primary key just like regular indexes.

[SANJAY_G]

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.

[rohitsn]

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

[tamilselvan]

Starting from 8i, an index on PK is not mandatory.

You can have a PK without index.