Re: Index management

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 11 May 2004 23:40:20 -0700
Message-ID: <1084344021.110414@yasure>

Howard J. Rogers wrote:

> Howard J. Rogers wrote:
>

>> Oh for gawd's sake. Please find out how indexes work.
>>
>> The clue is in the words "empty blocks". What do you think PCTUSED of 
>> zero means for an index block, exactly?
>>

>
> Upon reflection, that post was made in the heat of the moment, and was
> unfair and unpleasant to Brian. So my apologies, and please let me
> explain properly why what you posted was wrong.
>
> Instead of ASCII art, let's do an actual test on a real database.
>
> Here is the baseline test.
>

Thank you Howard ... thank you for a code demo that we can use to evaluate what is being discussed here. Mike ... can we get the same from you? Something we can try ourselves?

Thanks.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed May 12 2004 - 01:40:20 CDT