Merry Christmas and a Happy Index Rebuild Free New Year !! December 23, 2007
Posted by Richard Foote in Uncategorized.trackback
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 …
Richard Foote's Oracle Blog 
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!
LikeLike
>> 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?
LikeLike
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,
Aman….
LikeLike
Thanks all for the comments both online (and mostly) offline, much appreciated. Will attempt to satisfy all the requests in the fullness of time.
LikeLike
>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.
LikeLike
Hi Brian
Consider both questions offically included in my to-do list !!
LikeLike
Thanx.
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.
LikeLike