REBUILD

Maintenance of fragmented Heap table–TIP #55

  Friends, In last post  post #54  we understood what is a Heap table. Now the challenge is what if this table is highly fragmented so. Now our task is to run maintenance of this highly fragmented table. So you have to run following command “ALTER TABLE  TABLENAME REBUILD; For example  I run the Rebuild …