View Single Post

   
  #8 (permalink)  
Old 02-23-2008, 08:58 AM
Richard Foote
 
Posts: n/a
Default Re: Index management

"Howard J. Rogers" <hjr@dizwell.com> wrote in message
news:409334fa$0$25007$afc38c87@news.optusnet.com.a u...
> 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:...r=&ie=UTF-8&oe
=UTF-8&selm=ant%259.39604%24jM5.100537%40newsfeeds.bigp ond.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



Reply With Quote