Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Informix
Expertise: Beginner
Aug 8, 2000

ALTER TABLE Command

Question:
I've archived/purged a few thousand rows of unnecessary data, but the disk space reading hasn't changed. Do I need to use the ALTER TABLE command to reclaim empty space from deleted rows?

Answer:
When rows are deleted, the space is not reclaimed until the table is rebuilt. An easy way is to alter the primary index to cluster. This rebuilds the table with the rows placed physically in the order of the primary key. Use this format:

ALTER INDEX  to cluster;
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap