Re: Index space reuse

From: "Art S. Kagel" <art.kagel@xxxxxxxxx>
Date: Thu, 18 Oct 2007 19:10:29 -0000

On Oct 18, 11:23 am, "Gilbert, Dale" <dale.gilb...@xxxxxxxxxxxxxxxxx>
wrote:

Does 7.31 reuse index slots after rows are deleted?

Thanks

Dale R. Gilbert
NCG Informix Database Engineering
Bank of America
dale.gilb...@xxxxxxxxxxxxxxxxx <mailto:dale.gil...@xxxxxxxxxxxxxxxxx>
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

.

Prev by Date: Re: IDS on a Mac?
Next by Date: Re: Calculate optimal value for DS_POOLSIZE
Previous by thread: Continuous log restore
Next by thread: Re: Index space reuse
Index(es):
- Date
- Thread

Relevant Pages

Re: Do you know what are some the cheapest gizmos (sp.) that I can buy so I can listen in on strange
... frequencies and portable phones. ... intercepting cell calls is illegal under Federal and in many state laws. ... Unless you work FOR America. ... of saying that that's "international" because you can't own outerspace ...
(alt.true-crime)
Re: How did Bush change the New World Order to the New World Disorder?
... America won her independence from another ... locked up in your padded cell. ... King George will gladly lock you up, and rape you for his pleasure. ... there would be no liberal dim party. ...
(alt.politics.bush)
Re: Do you know what are some the cheapest gizmos (sp.) that I can buy so I can listen in on strange
... frequencies and portable phones. ... intercepting cell calls is illegal under Federal and in many state laws. ... Unless you work FOR America. ...
(alt.true-crime)
Re: Finding most common word in a list
... in an empty cell type ... explanation is to find out number of times "america" comes in row 1. ... In each cell is ...
(microsoft.public.excel.programming)