jump to navigation

Request Time (Join The Gang) July 11, 2008

Posted by Richard Foote in Richard's Musings.

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.


1. Tony - July 11, 2008

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?


2. Brian Tkatch - July 11, 2008

When is a partition better than just a regular INDEX.


3. kenny - July 11, 2008

I’m still trying to catch up with your earlier posts!

I think the level of detail is adequate.

Thanks Richard.


4. Bert Thomas - July 11, 2008

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.


5. Tony - July 11, 2008

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?


6. Neil - July 11, 2008

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.


7. Connor McDonald - July 13, 2008

Ditch snap preview….on my god, that is surely the worst invention in the world.


8. Connor McDonald - July 13, 2008

and yes, I do know I can disable them with an option…but this is a larger, moral, philosophical and ethical stance 🙂


9. karthick - July 14, 2008

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.



10. SeánMacGC - July 16, 2008

Steady as she goes Richard, pitched just about right I’d say, and thanks for the efforts.


11. Gabor Kecskemeti - July 16, 2008

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.


12. Chris Adkin - July 16, 2008

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.




13. Richard Foote - July 21, 2008

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.


14. Scott - July 21, 2008

When are we gonna see you give a seminar in the states???


15. Richard Foote - July 22, 2008

Hi Scott

Maybe next year ?


16. Richard Foote - July 28, 2008

Hi Connor

Consider snap preview ditched, now I found how to do it 🙂


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: