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

Public Appearances

I’ll be presenting “10 Things You Possibly Don’t Know About Indexes” at the InSync11 Conference in Sydney on 16-17 August 2011.

Please contact me at richard.foote@bigpond.com for further information or availability.

• 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

  	Andrew Reid on DEL_LF_ROWS Index Rebuild Crit…
  	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…

• 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,020,548 hits

• Richard Foote’s Tweets

  • Very very sad news on the passing of Trevor Bolder, David Bowie's bass player from the classic Spiders from Mars. RIP guardian.co.uk/music/2013/may… 19 hours ago
  • @rosssolly @666canberra And the next time someone accuses Canberra of being dull and boring we have the perfect comeback, #skywhale !! 1 day ago
  • @rosssolly @666Canberra #skywhale has promoted Canberra overseas to many who thought Sydney was our capital. Good on her, she's fantastic!! 1 day ago
  • @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. 3 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. 3 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-… 3 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… 4 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… 4 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 :) 5 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… 5 days ago
  • @FYPFanzine That we're a better team than Brighton (obviously) and that we're in a better position now than Wigan !! #cpfc 1 week 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

• 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)
  • Index Rebuild vs. Coalesce vs. Shrink Space (Pigs - 3 Different Ones)
  • Presentations & Demos
  • NOVALIDATE Constraints - No really ...
  • Primary Keys and Non-Unique Indexes (What's Really Happening ?)
  • Introduction To Reverse Key Indexes: Part I
  • DBMS_STATS METHOD_OPT default behaviour changed in 10g. Be careful ...
  • Oracle11g: Analyze Table Validate Structure Cascade "FAST" (Slow Burn)
  • Index Compression Part I (Low)
  • Prague, Czech Republic
  • Clustering Factor Calculation Improvement Part II (Blocks On Blocks)

• 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

• May 2013

  M	T	W	T	F	S	S
  « Apr
  		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