The reason for this is that when rows are deleted, the pages/extents that
are freed up are not returned to the free pool unless "there is an alter
index to cluster" or the table is rebuild.
When the page is complete freed, there is a bitmap page within the
partition which indicates that the page is available for reuse, but only
for that partition.
--------------------------------------------------------------------------
---------
Subject: systabinfo and sysfragments HELP...
From: Robert Donat <rdonat@sigg.com>
Date: Wed, 12 Mar 1997 13:22:12 -0600
Message-ID: <33270264.76AC@sigg.com>
Does anyone know the exact details of the columns in each? What I need
it to know the following:
Of a given extent, for a given fragmented table, HOW MUCH IS USED? (not
just how much is allocated).
The best I've been able to determine is the ti_nptotal and ti_npused
columns of the systabinfo table where ti_partnum is in the fragments for
the table I'm interested in. But, for tables on different servers with
slightly different numbers of rows but the same extents and definition
(roughly 20 pages worth of rows exist on one but not the other), the
numbers seem to match. When I insert a large number of rows, the
numbers stay the same. Any definitions on these columns, or ti_npdata
as well?
Thanks in advance,
Rob Donat.
--
_________________________________
Madison Pruet