Re: logical and physical size
Informix allocates table space in entities called extents. i.e. it
does not allocate new space every time you insert a row. Now when you
delete data they just flag the data as 'deleted' so that it can be
reused. So to answer your question -> you have top rebuild the table.
The least complicated way of doing this is to alter an index for
the table to cluster:
ALTER INDEX <index_name> TO CLUSTER; -- run in dbaccess
You could also recreate the table.
-Bill
}
} What version of informix are you running and is it SE/Online?
} --------------------------( Forwarded letter 1 follows )---------------------
} Date: Wednesday, 4 June 1997 10:57am
} Date: Wed, 04 Jun 1997 12:14:34 -0500
} From: Chengteh Lee <acustaf!clee@acustaf.acustaf.com>
} To: informix-list@rmy.emory.edu
} Subject: logical and physical size
} Sender: informix-list-owner@rmy.emory.edu
} Reply-To: clee@acustaf.acustaf.com@acustaf
} X-Informix-List-Id: <list.14798>
}
} Hi:
}
} I have a table growing really big and I try to
} delete some of the records.
} After I delete records, the physical size of the
} table doesn't reduce as we expect. Do I need
} to use informix command to reduce the physical size?
} How?
}
} Thanks!
}
} Chengteh
} ------------------------------------------------------------
} AcuStaf Corporation Automated Staffing Systems
} 5001 West 80th Street Payroll, Scheduling
} Minneapolis, MN 55437 Time/Attendance ...
} 612-831-4122 ext 248 http://www.acustaf.com
} ------------------------------------------------------------
}
--
Bill Ennis Voice: 312-474-7516
SSA Fax: 312-474-7460
500 W. Madison email: ennis@ssax.com ennis@accesschicago.net