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

• Contact Details

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

• Richard's Blogroll

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

• Richard's Music Links

  • David Bowie Bowienet
  • 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 OakTable Network
  • Oracle Technology Network

• Recent Comments

  	Jonathan Lewis on An Index Only Performs How Muc…
  	Richard Foote on An Index Only Performs How Muc…
  	Narendra on An Index Only Performs How Muc…
  	Richard Foote on Rebuilding Indexes Every Sunda…
  	Neil Johnson on Rebuilding Indexes Every Sunda…
  	Richard Foote on Zurich and Paris: Nice Way To …
  	Richard Foote on An Index Only Performs How Muc…
  	Richard Foote on An Index Only Performs How Muc…
  	Richard Foote on An Index Only Performs How Muc…
  	Richard Foote on An Index Only Performs How Muc…
  	Narendra on An Index Only Performs How Muc…
  	David Aldridge on An Index Only Performs How Muc…
  	PdV on An Index Only Performs How Muc…
  	yves on Zurich and Paris: Nice Way To …
  	Marcin Przepiorowski on An Index Only Performs How Muc…

• Recent Posts

  • An Index Only Performs How Much Work ???
  • Zurich and Paris: Nice Way To Spend A Week
  • Rebuilding Indexes Every Sunday Afternoon !!
  • Oracle OpenWorld – Day 5 Hightlights
  • Oracle Openworld – Day 4 Highlights
  • Oracle OpenWorld 2009 – Day 3 Highlights
  • Oracle OpenWorld 2009 – Day 2 Highlights
  • Oracle OpenWorld 2009 – So It Begins …
  • Unconference – Highlight of Oracle OpenWorld 2009
  • The CBO CPU Costing Model and Indexes – Another Introduction
  • Lanyon United Masters Div 3 Football Premiers 2009 (We Are The Champions)
  • Malaysia and Tall Buildings
  • OPTIMIZER_INDEX_CACHING Parameter
  • Demonizing Foreign Keys (“Helden”)
  • The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part III

• Blog Visits

  • 296,444 hits

• Archives

  • 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

  • An Index Only Performs How Much Work ???
  • Rebuilding Indexes Every Sunday Afternoon !!
  • Index Rebuild vs. Coalesce vs. Shrink Space (Pigs - 3 Different Ones)
  • Differences between Unique and Non-Unique Indexes (Part III)
  • OPTIMIZER_INDEX_CACHING Parameter
  • Richard Foote
  • Deleted Index Entries Part V (Trouble)
  • Differences between Unique and Non-Unique Indexes (Part I)
  • Index Internals Seminar
  • Radiohead "In Rainbows" Box-Set
  • How To Really Create A Function-Based Index (A Day In The Life)
  • The CBO CPU Costing Model and Indexes - Another Introduction

• Richard’s Categories

  Select Category 11g  (6) Backup and Recovery  (2) Bitmap Indexes  (1) Buffer Cache Hit Ratio  (2) CBO  (4) Clustering Factor  (2) Concatenated Indexes  (4) Constraints  (10) Deferrable Constraints  (2) Direct-Path Inserts  (1) Extended Statistics  (1) Extent Management  (1) Fake Indexes  (1) Flashback  (1) Foreign Keys  (2) Fragmented Indexes  (2) Function Based Indexes  (3) Humour  (4) Index Access Path  (13) Index Block Size  (8) Index Block Splits  (4) Index Coalesce  (4) Index Compression  (4) Index Delete Operations  (7) Index Height  (6) Index Internals  (17) Index Monitoring  (2) Index Organized Tables  (1) Index Rebuild  (7) Index Shrink  (4) Index Skip Scan  (1) Index statistics  (9) Indexing NULLs  (2) Indexing Tricks  (8) Invisible Indexes  (2) Kaleidoscope  (1) Linguistic Indexes  (2) Local Indexes  (1) Locking Issues  (1) Music  (6) Non-Unique Indexes  (4) NOSEGMENT Option  (1) NOT Equal  (1) Novalidate Constraints  (3) Olympics  (1) OOW  (1) OPTIMIZER_INDEX_COST_ADJ  (3) Oracle ACE Director  (2) Oracle Blog  (6) Oracle Cost Based Optimizer  (30) Oracle General  (45) Oracle Index Seminar  (2) Oracle Indexes  (88) Oracle Mix  (1) Oracle Myths  (35) Oracle OpenWorld  (5) Oracle Opinion  (12) Outlier Values  (1) Partitioning  (3) Performance Tuning  (29) Primary Key  (5) Radiohead  (4) Read Only  (1) Reverse Key Indexes  (4) Richard Presentations  (1) Richard’s Musings  (35) Root Index Block  (1) ROWID  (1) Shrink Index  (1) Small Indexes  (7) System Statistics  (1) Tablespace Management  (11) Total Recall  (1) Travel  (9) Uncategorized  (4) Unique Indexes  (10) Update Indexes  (2) Virtual Indexes  (1)

• Richard's Cloud

  11g Constraints Humour Index Access Path Index Block Size Index Compression Index Delete Operations Index Height Indexing Tricks Index Internals Index Rebuild Index statistics Music Non-Unique Indexes Oracle Blog Oracle Cost Based Optimizer Oracle General Oracle Indexes Oracle Myths Oracle OpenWorld Oracle Opinion Performance Tuning Primary Key Radiohead Richard's Musings Small Indexes Tablespace Management Travel Uncategorized Unique Indexes

• Feeds

• Full
• Comments