Table and index Extent Sizing ?
From: yakub <yakub_at_erols.com>
Date: Mon, 26 Feb 2001 07:28:59 -0500
Message-ID: <3A9A4C0B.9C1BBFDA_at_erols.com>
Date: Mon, 26 Feb 2001 07:28:59 -0500
Message-ID: <3A9A4C0B.9C1BBFDA_at_erols.com>
[Quoted] [Quoted] I have updated an algorythm that computes the initial and next extents [Quoted] with respect to space management of data and indexes . That is, I compute for the Space Available for Data (SAD) based on average rowsize, PctFree and blocksize.
[Quoted] Question 1: Does anyone have an algorthym that can be used to compute
the initial and next extents sizes?
[Quoted] Question 2: Should one also strive to get all of the data into one
extent?
Please explain.
Thanks,
Yakub
Received on Mon Feb 26 2001 - 13:28:59 CET