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

• 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

  	Puzzled on An Index Only Performs How Muc…
  	Niall Litchfield on Rebuilding Indexes Every Sunda…
  	Richard Foote on Rebuilding Indexes Every Sunda…
  	Richard Foote on An Index Only Performs How Muc…
  	Hemant K Chitale on Rebuilding Indexes Every Sunda…
  	Henish on An Index Only Performs How Muc…
  	Richard Foote on An Index Only Performs How Muc…
  	Richard Foote on Rebuilding Indexes Every Sunda…
  	Richard Foote on Rebuilding Indexes Every Sunda…
  	Richard Foote on Rebuilding Indexes Every Sunda…
  	Puzzled on An Index Only Performs How Muc…
  	Puzzled on An Index Only Performs How Muc…
  	Andy on Rebuilding Indexes Every Sunda…
  	J. on Rebuilding Indexes Every Sunda…
  	Niall Litchfield on Rebuilding Indexes Every Sunda…

• Recent Posts

  • The CBO CPU Costing Model: Indexes vs. Full Table Scans
  • 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”)

• Blog Visits

  • 303,061 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

  • The CBO CPU Costing Model: Indexes vs. Full Table Scans
  • An Index Only Performs How Much Work ???
  • Rebuilding Indexes Every Sunday Afternoon !!
  • Index Rebuild vs. Coalesce vs. Shrink Space (Pigs - 3 Different Ones)
  • DBMS_STATS METHOD_OPT default behaviour changed in 10g. Be careful ...
  • Presentations & Demos
  • The CBO and Indexes: An Introduction (Absolute Beginners)
  • Index Compression Part I (Low)
  • Index Compression Part II (Down Is The New Up)
  • Introduction To Reverse Key Indexes: Part I
  • NOVALIDATE Constraints - No really ...
  • Index Scan or Full Table Scan: The "Magic" Number (Magic Dance)

• Richard’s Categories

  Select Category 11g  (6) Backup and Recovery  (2) Bitmap Indexes  (1) Buffer Cache Hit Ratio  (2) CBO  (5) 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) Full Table Scans  (1) 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  (89) 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  (2) Tablespace Management  (11) Total Recall  (1) Travel  (9) Uncategorized  (4) Unique Indexes  (10) Update Indexes  (2) Virtual Indexes  (1)

• Richard's Cloud

  11g CBO Constraints Humour Index Access Path Index Block Size 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