Not sure of the question. Are you asking if the space is reclaimed? Does the physical size of the index decrease? Or are asking if the space on disk for the record's index is wiped clean and remains unused until the file is moved, reorganized, or some other activity that causes a rewrite of the data?

On 2/3/2014 12:57 PM, Alan Campin wrote:
Does anybody know. If you delete a record, does the index size decrease?

I am getting indications both way, that it keeps the deleted record in
index and logical indexes and other stuff that seems to say it deletes the
record from the indexes.

I found IBM's information on calculating index size but it only says number
of records and nothing about deleted record.

It would seem logical that it would not keep an entry in the index.

Anyway, thanks. .

This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page