Index space reuse
Dale Gilbert asked whether IDS 7.31 reuses index slots after rows are deleted. Art S. Kagel answered yes, and added that empty and mostly empty index nodes are compressed in the background by the btree cleaner threads. His reply was posted three times.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Does 7.31 reuse index slots after rows are deleted? Thanks Dale R. Gilbert NCG Informix Database Engineering Bank of America dale.gilbert@bankofamerica.com <mailto:dale.gilber@bankofamerica.com> Phone: (302) 457-4186 Cell: (858) 449-7459
On Oct 18, 11:23 am, "Gilbert, Dale" <dale.gilb...@bankofamerica.com> wrote: > Does 7.31 reuse index slots after rows are deleted? > > Thanks > > Dale R. Gilbert > NCG Informix Database Engineering > Bank of America > dale.gilb...@bankofamerica.com <mailto:dale.gil...@bankofamerica.com> > Phone: (302) 457-4186 > Cell: (858) 449-7459 Yes. Also empty nodes are compressed by the BTree cleaner threads in the background. Art S. Kagel
On Oct 18, 11:23 am, "Gilbert, Dale" <dale.gilb...@bankofamerica.com> wrote: > Does 7.31 reuse index slots after rows are deleted? > > Thanks > > Dale R. Gilbert > NCG Informix Database Engineering > Bank of America > dale.gilb...@bankofamerica.com <mailto:dale.gil...@bankofamerica.com> > Phone: (302) 457-4186 > Cell: (858) 449-7459 Yes. Also empty and mostly empty index nodes are compressed by the btree cleaner threads in the background. Art S. Kagel
On Oct 18, 11:23 am, "Gilbert, Dale" <dale.gilb...@bankofamerica.com> wrote: > Does 7.31 reuse index slots after rows are deleted? > > Thanks > > Dale R. Gilbert > NCG Informix Database Engineering > Bank of America > dale.gilb...@bankofamerica.com <mailto:dale.gil...@bankofamerica.com> > Phone: (302) 457-4186 > Cell: (858) 449-7459 Yes. Also empty and mostly empty index nodes are compressed by the btree cleaner threads in the background. Art S. Kagel