jump to navigation

Merry Christmas and a Happy Index Rebuild Free New Year !! December 23, 2007

Posted by Richard Foote in Uncategorized.

To those of you who celebrate Christmas and happen to stumble occasionally across these humble Blog entries, I would just like to wish you all a wonderful, joyful Christmas and a safe and prosperous New Year.

I’ve now been doing this Blogging thing for nearly two weeks, hasn’t time just flown by !!

Reaction to the Blog has generally been really positive so thank-you all for your encouraging comments both on and offline. If you haven’t done so already, please let me know what you think about some of the things I’ve covered thus far. Has it been at all useful, interesting, thought provoking, educational, or has it generally been boring, overlong, impractical and in danger of losing touch with reality.

Are there any specific things or topics you might like covered or discussed in the future or should I just spend more time talking about Radiohead ?

Any thoughts or opinions, on or offline would be greatly appreciated.

I’m off now to wrap some presents …


1. Alberto Dell'Era - December 23, 2007

Your blog is one of my Firefox’s home pages, that means that I read it daily and frequently hit the “Refresh” button – that clearly shows how much I find it interesting, thought provoking etcetera ;).

Probably Oracle is our most common interest, yet I like the occasional article about Radioheads or Bowie, or anything else outside the Oracle “domain of knowledge” (BTW “The Rise and Fall of Ziggy Stardust and the Spiders from Mars” is a favorite of mine – I have the CD in the car even today).

Merry Xmas to you and all your readers!


2. Donald K. Burleson - December 23, 2007

>> I would just like to wish you all a wonderful, joyful Christmas and a safe and prosperous New Year.

You too!

I wonder how many DBA’s will spend Cheistmas Day reorging Oracle and rebuilding indexes?


3. Aman Sharma - December 26, 2007

HI sir,
Wish you a very happy and prosperous 2008.May god give his choicest blessings to you. And belated Marry Xmas to you.
About the wish list,I am not sure that which one actually will be good but this is some thing which I want to read about from you.
1) Indexes Access Paths and their importance. How to pick the best ones for the query performance looking at the cardinality and other factors to say that indexes should be used here or not or some other type of indexes may be used.
2) Index internals and dumping commands information elaborated.How they can be effectively used for deciding the performance of the query?
3) Discussion for the use of various hints(documented as well as non-documented) to decide the maximum use of indexes for the maximum benefit.Why/where they can be used and most importantly why not?
3) Use of 10g ( also now 11g) advisories to tune indexes for their queries.
Hmm can’t remember much now sir. I guess we have this option that the list can be subsequently modified and increased right :-)!
Wish you happy holidays!
Warm regards,


4. Richard Foote - December 28, 2007

Thanks all for the comments both online (and mostly) offline, much appreciated. Will attempt to satisfy all the requests in the fullness of time.


5. Brian Tkatch - January 3, 2008

>Are there any specific things or topics you might like covered or
>discussed in the future or should I just spend more time talking
>about Radiohead ?

Two cases come to mind that i would like to see pertaining to INDEXes.

1) If a TABLE has a lot on INSERTs and DELETEs, resulting between zero and thousands of rows (like a TABLE holding batch data).

2) If a TABLE has millions of records separated into thousands of groups (via an FK). When to use an INDEX, and when to use partitions.

I am ignorant in these areas. I would love to see them specifically addressed.


6. Richard Foote - January 4, 2008

Hi Brian

Consider both questions offically included in my to-do list !!


7. Brian Tkatch - January 4, 2008


Both of these issues are happening in the group i now work with. I would love to see if we can improve performance in these areas. Currently, i’m concentrating on making sense of (and rewriting) some very patch PL/SQL code.


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: