Fragmentation in Primary Key
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Fragmentation in Primary Key

  1. #1
    Join Date
    Nov 2000
    Posts
    205
    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

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I guess you can rebuild primary key just like regular indexes.
    Reddy,Sam

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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.

  4. #4
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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
  •  



Click Here to Expand Forum to Full Width