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

  	Woodrow on Upcoming Index Seminar Dates (…
  	chwilówka przez inte… on Storage Indexes vs Database In…
  	Juana on Introduction To Reverse Key In…
  	chwilówki przez inte… on Storage Indexes vs Database In…
  	Most Twitter Followe… on Curious Case Of The Ever Incre…
  	Rebuild Required Myt… on DEL_LF_ROWS Index Rebuild Crit…
  	vijay on Storage Indexes vs Database In…
  	reputationchanger.co… on IOT Secondary Indexes –…
  	Richard Foote on I’m Back !! Oracle Index…
  	Richard Foote on Introduction To Reverse Key In…
  	Santosh on Introduction To Reverse Key In…
  	Martin Preiss on Clustering Factor Calculation…
  	Richard Foote on Clustering Factor Calculation…
  	Richard Foote on Important !! Clustering Factor…
  	Richard Foote on Clustering Factor Calculation…

• 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,035,562 hits

• Richard Foote’s Tweets

  • @UweHesse If the quality of your blog is anything to go by, I'm sure your seminar will be a great success :) 1 week ago
  • Great performance here by the mighty #socceroos. Just one game away now from our third straight World Cup. 1 week ago
  • Come on #Socceroos, the job is only 1/2 done so far. 1 week ago
  • @UweHesse Welcome to the #Oracle Expert seminar club :) 1 week ago
  • I love public holidays so thank you Your Majesty, even though it's not actually your birthday today. 1 week ago
  • Perhaps the best rock doco ever made, 1974 Cracked Actor film made about David Bowie. A totally fascinating insight: youtube.com/watch?v=HnIBBk… 1 week ago
  • I've never been to Bucharest before. If you had a couple of free days in Bucharest, what would you do ??? 1 week ago
  • It took us nearly 2 hours to drive 15km down the M5 in Sydney. Don't know how people can stand it. #SlowSydneyTraffic #FastCanberraTraffic 1 week ago
  • Finally my index seminar in Bucharest has been placed in the correct Oracle Database category. Places filling up fast education.oracle.co.uk/html/oracle/28… 1 week ago
  • @FYPFanzine @MattWoosie Let's aim higher, we're in the EPL. I say Gareth Bale, Leighton Baines, Cesc Frabregas, Wesley Sneijder and Ronaldo! 2 weeks ago
  • The picture quality from WIN/channel 9 of the State of Origin is terrible. How I wish this was on live on Fox instead !! 2 weeks ago
  • There are very few places on this planet better than beautiful Canberra in winter to go for a lunch-time jog: blog.ching-teoh.com/2012_08_01_arc… 2 weeks ago
  • I usually go for the team with the most Raiders in State of Origin. Else, coach who might be a Raider's legend. Going to be tricky tonight. 2 weeks ago
  • So it ends one all. A good point on the end. Well done Soccerroos. Rio is looking good now. 2 weeks ago
  • Goal to Japan. Jedinak would have saved it. One all. Damn. 2 weeks ago

• Recent Posts

  • Clustering Factor Calculation Improvement Part III (Too Much Rope)
  • 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)

• Archives

  • June 2013
  • 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)
  • NOVALIDATE Constraints - No really ...
  • Index Compression Part I (Low)
  • Index Rebuild vs. Coalesce vs. Shrink Space (Pigs - 3 Different Ones)
  • Differences between Unique and Non-Unique Indexes (Part I)
  • Oracle11g: Analyze Table Validate Structure Cascade "FAST" (Slow Burn)
  • Introduction To Reverse Key Indexes: Part II (Another Myth Bites The Dust)
  • Primary Keys and Non-Unique Indexes (What's Really Happening ?)
  • DBMS_STATS METHOD_OPT default behaviour changed in 10g. Be careful ...
  • Introduction To Reverse Key Indexes: Part I

• Richard’s Categories

  Select Category 11g  (19) 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  (27) Christmas  (4) Clustering Factor  (13) 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  (12) 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) TABLE_CACHED_BLOCKS  (1) 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

• June 2013

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

• Feeds

• Full
• Comments