Re: Index management

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:409334fa$0$25007$afc38c87_at_news.optusnet.com.au...
> Richard Foote wrote:
> >
> > Go to the download section at www.actoug.org.au, make what you can of
the
> > PowerPoint presentation, wait for the accompanying whitepaper/book, read
it
> > carefully too and hopefully you'll get the picture.
>
> Is there an emoticon for a big, BIG, BIIIIIIGGGG beaming smiley face.

Hi Howard,

I'm not sure. What about :) x 100 !!

>
> After having read the first slides containing the delicious quotes from
> Herr Burleson und seiner freunde, I had to go and bake a doughnut.

The difficult part was selecting which quotes to use, there are so many. I didn't want to single out any one person and I wanted to highlight how so many have got it so wrong. So I focused on those "experts" that seem to publish a lot of "stuff" ...

>
> After that I had indigestion with your 50-50 leaf block claim. Jonathan
> claims it's 50-50 *on average*, but not by volume, I think. Interesting.

No, it's definitely by volume. I showed this in a thread here a while back where after a leaf block split, the number of index entries in each block varied but the amount of used space sat at the 50% mark in each block.

Look here:
http://groups.google.com/groups?q=g:thl1973251333d&dq=&hl=en&lr=&ie=UTF-8&oe =UTF-8&selm=ant%259.39604%24jM5.100537%40newsfeeds.bigpond.com. where I demonstrate my "volume" claim The white paper also has an example.

It's the same thread whereby Don Burleson showed his total ignorance of how indexes work and kinda opened my eyes that he wasn't quite what he claimed. Interestingly, almost the entire history of Don Burleson posts have been removed from the google archives, there's hardly a one left. As an example, all the posts in this thread where he made a fool of himself are no longer there, although thankfully for prosperity sake, his "words of wisdom" can still be found in among the posts of others. It's all very interesting don't you think, although it's probably a good move from Don's point of view to reduce the embarrassment of some of the stuff his written.

>
> However: I just wanna know why that Sharman guy gets all the invites and
> I don't :-((
>

A lot of it has to do with the fact he's a local lad who lives in the neighbouring suburb from me !! However, our next User Group event is on 23 June so if your interested in conducting a presentation in front of 60 odd folks and would like a lovely free lunch to boot, please let me know and I'll grab you a spot no worries at all !!

Cheers

Richard Received on Sat May 01 2004 - 03:06:54 CDT