Re: Table has no rows but has lots of pages

Posted in 2004

Andy Kent — 4 Mar 2004 01:03:22 -0800 — source: Usenet: comp.databases.informix

> ALTER FRAGMENT ON mytable INIT IN <dbspacename or fragment expression>; Does this rebuild the table? OK, not exactly an issue with no rows, but could be if you still had some left ... Andy

↪ replying to Andy Kent

Art S. Kagel — Thu, 04 Mar 2004 08:50:08 -0500 — source: Usenet: comp.databases.informix

On Thu, 04 Mar 2004 04:03:22 -0500, Andy Kent wrote: >> ALTER FRAGMENT ON mytable INIT IN <dbspacename or fragment expression>;> > Does this rebuild the table? OK, not exactly an issue with no rows, but > could be if you still had some left ... Yes, the ALTER FRAGMENT...INIT IN... statement performs a very fast reorg on your table and tends to use fewer resources than that old standby ALTER INDEX ... TO CLUSTER; Art S. Kagel

Glossary

dbspace