Re: index rebuilding...

From: Noons <nsouto_at_optusnet.com.au.nospam>
Date: 05 Feb 2003 12:05:10 GMT
Message-ID: <Xns9319E86EEC12Dmineminemine@210.49.20.254>

Noons <nsouto_at_optusnet.com.au.nospam> wrote in news:Xns9319E5D9D8AE8mineminemine_at_210.49.20.254 and I quote:

> I mean: fine, if it is a matter of finding a free extent,
> it can use whatever algorithm. But once a free extent
> of 16 blocks is allocated, why would it then have to
> allocate anywhere else other than after the segment header?

Sorry, just re-read this and it doesn't make the point I wanted. This is more to it:

It's ok to use an algorithm for selecting an extent for the data segment out of the pool of free extents.

But why use yet another algorithm for allocating data blocks to the table *within* an already allocated extent?

As I said later on: FREELISTS?

-- 
Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam

Received on Wed Feb 05 2003 - 06:05:10 CST