Oninit cdi / Archive
Talk to an expert →

Index space reuse

Posted in 2007

Topics: General Discussion

Gilbert, Dale — — source: Usenet: comp.databases.informix

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

↪ replying to Gilbert, Dale
Art S. Kagel — — source: Usenet: comp.databases.informix

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

↪ replying to Gilbert, Dale
Art S. Kagel — — source: Usenet: comp.databases.informix

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

↪ replying to Gilbert, Dale
Art S. Kagel — — source: Usenet: comp.databases.informix

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