Request Time (Join The Gang) July 11, 2008
Posted by Richard Foote in Richard's Musings.trackback
I’ve just passed yet another milestone since starting this Blog. I’ve just deleted my 500th spam comment.
How exciting is that !!
To celebrate this momentous occasion, I thought I might open up the Blog to some requests and suggestions.
Are there any particular topics you would like covered ? Is there something I might already have previously touched upon you think would be worth expanding ? Do you think I go into too much detail or too little ? Are you still annoyed I got you on April Fool’s day or are you simply hanging out to find out what my favourite top 10 movies of all time might be 🙂
Or maybe it’s simply just a case of more of the same please ?
There’s still a whole heap to index related topics I haven’t even touched yet however I thought it might be worth touching base with those of you who read these humble little posts regarding what might be of interest going forward.
I won’t promise to be able to meet each and every request but it’s an opportunity for you to at least get me thinking about what might be worth covering and how to best to discuss them.
Last time I did something similar, I received far more emails than blog comments and that’s fine if you prefer to make suggestions offline.
More of the same is good. I surely don’t think you are providing too much detail. It’s great to see the work behind the answers (see Cary’s Milsaps message about showing showing your work).
I would like to know your thoughts on IOT’s. Should more tables be structured this way?
LikeLike
When is a partition better than just a regular INDEX.
LikeLike
I’m still trying to catch up with your earlier posts!
I think the level of detail is adequate.
Thanks Richard.
LikeLike
Advanced “Explain Plan” reading would be very useful.
As we go from 9i to 10g and onwards, understanding each step and
each operation is getting more and more complex.
Thank you.
LikeLike
For partitioned tables – global versus local indexes, when and why?
What’s the deal with indexing virtual columns?
When, if at all, function based indexes can come back to haunt you?
LikeLike
I’ll second Tony’s comments – more of the same, your blog is an excellent source of information and also IOTs would be a good topic.
Thanks
LikeLike
Ditch snap preview….on my god, that is surely the worst invention in the world.
LikeLike
and yes, I do know I can disable them with an option…but this is a larger, moral, philosophical and ethical stance 🙂
LikeLike
All the post by you in this blog is great. It gives me a great amount of information about index. The details that you provide help me validate the information myself which is very much appreciated. Keep up the great work.
Thanks,
Karthick.
LikeLike
Steady as she goes Richard, pitched just about right I’d say, and thanks for the efforts.
LikeLike
I second the IOT and index partitioning questions (partitioned IOTs? 🙂 ), and also if it fits your profile would like to hear a bit about Oracle clusters. Look at the 3 (technically 2) cluster types (single table hash, hash, index), pros / cons, some practical scenarios when it’s worth using them, etc.
LikeLike
Hi Richard,
I would like you to cover index organized tables and the nuances of costing involving operations on them, considering such things as the primary key having a zero clustering factor and what the optimizer does with table look up by rowid as there is concept of an absolute rowid in an IOTs. Although Jonathan Lewis has not cothered IOTs in his Cost Based Optimizer Fundamentals book explicitly, he does allude to special cases involving the optimizer and IOTs.
Regards,
Chris
LikeLike
Hi All
Thanks for all the comments and emails.
Looks like IOTs and partitioning are worth exploring. Will look at including as many of the suggestions as I can in the near future.
LikeLike
When are we gonna see you give a seminar in the states???
LikeLike
Hi Scott
Maybe next year ?
LikeLike
Hi Connor
Consider snap preview ditched, now I found how to do it 🙂
LikeLike