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