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

• Public Appearances

  • France 5-6 November (2 Day Index Internals and Best Practices Seminar)
  • India 22-26 February 2010 (2 Day Index Internals And Best Practices Seminar)
  • Switzerland: 2-3 November (2 day Index Internals And Best Practices Seminar)

• 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

  	baskar.loganathan on OPTIMIZER_INDEX_CACHING P…
  	joel garry on Store Indexes In A Larger Bloc…
  	Jonathan Lewis on The CBO CPU Costing Model and …
  	Daniel M. Kimethu on The CBO CPU Costing Model and …
  	Stellios on Rebuilding Indexes Every Sunda…
  	Nayab on Rebuilding Indexes Every Sunda…
  	Centinul on Rebuilding Indexes Every Sunda…
  	Fahd Mirza on Rebuilding Indexes Every Sunda…
  	Log Buffer #167: a C… on Rebuilding Indexes Every Sunda…
  	Kevin on Rebuilding Indexes Every Sunda…
  	Ben Burrell on Rebuilding Indexes Every Sunda…
  	Richard Foote on It’s Less Efficient To H…
  	Richard Foote on Rebuilding Indexes Every Sunda…
  	Richard Foote on Rebuilding Indexes Every Sunda…
  	Tom on It’s Less Efficient To H…

• Recent Posts

  • 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
  • Upcoming Index Internals and Best Practices Seminar Dates
  • The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part II

• Blog Visits

  • 292,861 hits

• Archives

  • 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

  • Presentations & Demos
  • Rebuilding Indexes Every Sunday Afternoon !!
  • DBMS_STATS METHOD_OPT default behaviour changed in 10g. Be careful ...
  • Index Rebuild vs. Coalesce vs. Shrink Space (Pigs - 3 Different Ones)
  • OPTIMIZER_INDEX_CACHING Parameter
  • Radiohead "In Rainbows" Box-Set
  • How To Really Create A Function-Based Index (A Day In The Life)
  • Index Compression Part I (Low)
  • Index Internals Seminar
  • Recommendations
  • The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part II
  • Primary Keys and Non-Unique Indexes (What's Really Happening ?)

• 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  (6) 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  (87) Oracle Mix  (1) Oracle Myths  (34) 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  (34) Root Index Block  (1) ROWID  (1) Shrink Index  (1) Small Indexes  (7) System Statistics  (1) Tablespace Management  (11) Total Recall  (1) Travel  (8) 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