Richard Foote's Oracle Blog

Focusing Specifically On Oracle Indexes, Database Administration and Some Great Music

• Home
• Richard Foote
• Presentations & Demos
• Index Internals Seminar
• Public Appearances
• Recommendations

• Disclaimer

  The views expressed on this blog are my own and do not necessarily reflect the views of Oracle Corporation.

• Contact Details

  If you wish to contact me directly, please do so at richard.foote@bigpond.com
• 
• 

• Recent Comments

  	Hotel Cost Compariso… on Curious Case Of The Ever Incre…
  	Richard Foote on Important !! Clustering Factor…
  	Richard Foote on Important !! Clustering Factor…
  	Amit Saraswat on Important !! Clustering Factor…
  	Новое в статистике |… on Clustering Factor Calculation…
  	Новое в статистике |… on Important !! Clustering Factor…
  	Clustering Factor Ca… on Important !! Clustering Factor…
  	Richard Foote on Oracle11g: Analyze Table Valid…
  	Richard Foote on Clustering Factor Calculation…
  	Richard Foote on Exadata Storage Indexes Part I…
  	Richard Foote on Visible Invisible Indexes (The…
  	Oracle Datenbanken on Oracle11g: Analyze Table Valid…
  	vipan on Clustering Factor Calculation…
  	Oracle Datenbanken on Exadata Storage Indexes Part I…
  	Clustering Factor Ca… on Important !! Clustering Factor…

• Richard's Blogroll

  • Alberto Dell’Era
  • Cary Millsap
  • Charles Hooper
  • Chris Muir
  • Christian Antognini
  • Doug Burns
  • Greg Rahn
  • Inside The Oracle Optimizer
  • Jonathan Lewis
  • Kevin Closson
  • Marcel Kratochvil
  • Mark Rittman
  • Pete Finnigan
  • Randolf Geist
  • Tanel Poder
  • Tom Kyte

• Richard's Music Links

  • David Bowie Bowienet
  • Muse Official Website
  • Pink Floyd A Fleeting Glimpse
  • Pink Floyd Brain Damage
  • Radiohead Dead Air Space
  • Radiohead Green Plastic

• Richard's Oracle Links

  • ACT Oracle User Group
  • Ask Tom
  • Oracle ACE Program
  • Oracle OakTable Network
  • Oracle Technology Network

• Blog Visits

  • 1,019,503 hits

• Richard Foote’s Tweets

  • @markrittman We're not promoted yet, we still have to beat Watford in the final next week. Still a chance we might yet meet again next year. 2 days ago
  • Beautiful Canberra day today. Not such a good football result with Lanyon losing 6-0 to Brindabella. The result hurts more than the bruises. 2 days ago
  • I've been a mad David Bowie fan for 34 years. Today marks 34 years since "Lodger", the first Bowie album I bought. youtube.com/watch?v=_o1Yu-… 2 days ago
  • The #Skywhale finally flew over Canberra this morning. Only a handful of young children ran screaming in terror :) canberratimes.com.au/act-news/suppo… 3 days ago
  • Wow, it's hard to imagine that Brighton FC would really poop, oops I mean stoop so low against the mighty #CPFC: thesun.co.uk/sol/homepage/s… 3 days ago
  • @NormanDunbar I think I'm one of the very few people on this planet that thinks the Skywhale is brilliant. I'm very proud of her :) 4 days ago
  • Missed out on getting a ride on the Canberra #skywhale tomorrow. Shame as it would have been a titillating experience abc.net.au/news/2013-05-1… 4 days ago
  • @FYPFanzine That we're a better team than Brighton (obviously) and that we're in a better position now than Wigan !! #cpfc 6 days ago
  • @NormanDunbar @wizofoz2k @Cmdr_Hadfield I think it's an idea worth floating around. Sorry, couldn't help myself :) 1 week ago
  • Hmm, thinking how the hell to get to Wembley to see the mighty #cpfc from Australia. The really tricky bit will be explaining it to my wife! 1 week ago
  • @wizofoz2k @NormanDunbar @Cmdr_Hadfield Let's hope not, we all need that sense of adventure. Perhaps the next guy can sing "Starman" :) 1 week ago
  • @NormanDunbar @wizofoz2k I think having people floating around in space makes life all that more interesting for those of us stuck on Earth. 1 week ago
  • @NormanDunbar @wizofoz2k It made all the news here in Australia. What a brilliant PR excerise to raise more awareness of the space mission. 1 week ago
  • @wizofoz2k Hi Noons. How cool is he!! It's got to be one of the most "authentic" Bowie covers ever, I mean it's a real "tin-can" after all!! 1 week ago
  • Clustering Factor Calculation Improvement Part II (Blocks On Blocks) wp.me/p9EK0-Ag 1 week ago

• Recent Posts

  • Clustering Factor Calculation Improvement Part II (Blocks On Blocks)
  • Important !! Clustering Factor Calculation Improvement (Fix You)
  • Storage Indexes vs Database Indexes IV: 8 Column Limit (Eight Line Poem)
  • 1,000,000 Blog Visits (How I Made My Millions)
  • I’m Back !! Oracle Index Internals Seminar Scheduled in Europe For June.
  • Storage Indexes vs Database Indexes Part III: Hidden Values (Hide Away)
  • Merry Christmas and A Happy New Year !! (The Snowman)
  • 5 Year Anniversary (5 Years)
  • Storage Indexes vs Database Indexes Part II: Clustering Factor (Fast Track)
  • Storage Indexes vs Database Indexes Part I MIN/MAX (Maxwell’s Silver Hammer)
  • Exadata Storage Indexes Part V: Warming Up (Here Come The Warm Jets)
  • Exadata Storage Indexes Part IV – Fast Full Table Scans (Speed of Life)
  • Exadata Storage Indexes Part III – Similarities With Database Indexes (Same Old Scene)
  • Exadata Storage Indexes Part II – Differences With Database Indexes (Space Dementia)
  • 250 Posts !!

• Archives

  • May 2013
  • April 2013
  • February 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • December 2008
  • November 2008
  • October 2008
  • September 2008
  • August 2008
  • July 2008
  • June 2008
  • May 2008
  • April 2008
  • March 2008
  • February 2008
  • January 2008
  • December 2007

• Richard Foote’s Pages

  • Richard Foote
  • Presentations & Demos
  • Index Internals Seminar
  • Recommendations
  • Public Appearances

• Top Posts

  • How Does An Execution Plan Suddenly Change When The Statistics (And Everything Else) Remains The Same ? (In Limbo)
  • Important !! Clustering Factor Calculation Improvement (Fix You)
  • NOVALIDATE Constraints - No really ...
  • Introduction To Reverse Key Indexes: Part I
  • Primary Keys and Non-Unique Indexes (What's Really Happening ?)
  • Prague, Czech Republic
  • Index Create and Rebuild Locking Improvements in 11g (Ch Ch Ch Changes)
  • Clustering Factor Calculation Improvement Part II (Blocks On Blocks)
  • Index Rebuild vs. Coalesce vs. Shrink Space (Pigs - 3 Different Ones)
  • DBMS_STATS METHOD_OPT default behaviour changed in 10g. Be careful ...
  • Presentations & Demos
  • Index Skip Scan - Does Index Column Order Matter Any More ? (Warning Sign)

• Richard’s Categories

  Select Category 11g  (18) 11g New features  (8) Advert  (2) ASSM  (3) Backup and Recovery  (2) Bitmap Indexes  (14) BLEVEL  (1) Block Dumps  (13) Buffer Cache Hit Ratio  (2) CBO  (26) Christmas  (4) Clustering Factor  (12) Collaborate 10  (1) Collaborate 2010  (1) Concatenated Indexes  (6) Constraints  (10) David Bowie  (1) Deferrable Constraints  (2) DEL_LF_ROWS  (1) Descending Indexes  (2) Direct-Path Inserts  (1) Exadata  (10) Extended Statistics  (1) Extent Management  (1) Fake Indexes  (2) Flashback  (1) Foreign Keys  (3) Fragmented Indexes  (2) Full Table Scans  (1) Function Based Indexes  (4) Histograms  (1) Hotsos Symposium  (1) Humour  (4) Index Access Path  (14) Index Block Size  (9) Index Block Splits  (4) Index Coalesce  (4) Index Compression  (4) Index Delete Operations  (7) Index Full Scan (Min/Max)  (1) Index Height  (6) Index Internals  (30) Index Monitoring  (2) Index Organized Tables  (12) Index Rebuild  (10) Index Shrink  (4) Index Skip Scan  (1) Index statistics  (11) Indexing Myth  (5) Indexing NULLs  (2) Indexing Tricks  (8) InSync10  (2) InSync11  (2) InSync12  (1) Invisible Indexes  (2) IOT  (9) Kaleidoscope  (1) Leaf Blocks  (1) Linguistic Indexes  (2) Local Indexes  (1) Locking Issues  (2) MAX  (2) Method_Opt Size AUTO  (1) MIN  (2) MINIMIZE RECORDS_PER_BLOCK  (1) Multiblock Reads  (2) Music  (6) Non-Unique Indexes  (5) NOSEGMENT Option  (1) NOT Equal  (3) Novalidate Constraints  (3) Olympics  (1) OOW  (5) OPTIMIZER_INDEX_COST_ADJ  (4) Oracle ACE Director  (2) Oracle Blog  (6) Oracle Bugs  (1) Oracle Cost Based Optimizer  (38) Oracle General  (45) Oracle Index Seminar  (6) Oracle Indexes  (166) Oracle Mix  (2) Oracle Myths  (39) Oracle OakTable  (1) Oracle OpenWorld  (10) Oracle Opinion  (12) Oracle Statistics  (2) Outlier Values  (1) Overflow Segment  (3) Partitioning  (3) PCTTHRESHOLD  (1) Performance Tuning  (29) Pink Floyd  (1) Primary Key  (9) Quiz  (15) Radiohead  (4) Read Consistency  (1) Read Only  (1) Reverse Key Indexes  (5) Richard Presentations  (1) Richard’s Musings  (51) Root Index Block  (1) ROWID  (3) Secondary Indexes  (6) Shrink Index  (1) Small Indexes  (9) Smart Scans  (3) Storage Indexes  (9) Sydney Oracle Meetup  (1) System Statistics  (7) Tablespace Management  (11) The Dark Side of the Moon  (1) Total Recall  (1) Travel  (11) Tree Dumps  (1) Uncategorized  (3) Unique Indexes  (12) Unusable Indexes  (2) Update Indexes  (2) Validate Structure  (2) Virtual Columns  (1) Virtual Indexes  (2) World Cup  (1)

• Richard's Cloud

  11g Bitmap Indexes Block Dumps CBO Clustering Factor Constraints Exadata Index Access Path Index Block Size Indexing Tricks Index Internals Index Organized Tables Index Rebuild Index statistics IOT Oracle Cost Based Optimizer Oracle General Oracle Indexes Oracle Myths Oracle OpenWorld Oracle Opinion Performance Tuning Primary Key Quiz Richard's Musings Small Indexes Storage Indexes Tablespace Management Travel Unique Indexes

• October 2012

  M	T	W	T	F	S	S
  « Sep				Nov »
  1	2	3	4	5	6	7
  8	9	10	11	12	13	14
  15	16	17	18	19	20	21
  22	23	24	25	26	27	28
  29	30	31

• Feeds

• Full
• Comments