MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » February 2014

Re: Deleted records and index size



fixed

Does the amount of disk space that the index occupies decrease. I am trying
to figure how much additional storage that a copy of a physical file and
it's logicals would require assuming that the deleted records are not
copied.


On Mon, Feb 3, 2014 at 12:02 PM, Booth Martin <booth@xxxxxxxxxxxx> wrote:

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. .

--
Booth Martin
www.martinvt.com
(802)461-5349
Skype: booth.martin

Never call a man a fool; borrow from him.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.







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

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact