Why and How to rebuild Primary Key?

~ 0 min
2017-01-12 03:27

 When face such as below questions we can also consider to rebuild primary key.

For example:

  1. Too much index expansion to cause the performance down (IO and CUP cost)
  2. DB Crash cause the PK data inconsistent.

We can rebuild primary key with following usage:

Rebuild index PRIMARYKEY for t1; //in default DEFTABLESPACE

Rebuild index PRIMARYKEY for t1 in ts1; //support change tablespace only from 5.4 versions

Version: All

Product: Normal/Bundle

Platform: Windows/Linux

Average rating 0 (0 Votes)

You cannot comment on this entry