Blogs about: Oracle Myths
Featured Blog
An Index Only Performs How Much Work ???
One of the main reasons suggested for performing periodic index rebuilds is to improve “performance”. After rebuilding indexes, applications now run so much faster. Users notice a signific… more →
Richard Foote's Oracle Blog
An Index Only Performs How Much Work ???
— 26 comments
Richard Foote wrote 2 weeks ago: One of the main reasons suggested for performing periodic index rebuilds is to improve “perfor … more →
Larger Block Tablespace For Indexes Revisited Part III (Prove Yourself)
— 6 comments
Richard Foote wrote 9 months ago: Time to look a little at an Index Fast Full Scan (IFFS) with respect to moving indexes into a larger … more →
Larger Block Tablespace For Indexes Revisted: Part II (Money)
— 7 comments
Richard Foote wrote 9 months ago: In Part I I looked at Robin Schumacher’s “classic” example of the “so-called … more →
Larger Block Tablespace For Indexes Revisited: Part I (The Tourist)
— 14 comments
Richard Foote wrote 9 months ago: I’ve previously discussed the various issues and myths relating to the so-called benefits of c … more →
Updates and Indexes Part II (Down Is The New Up)
— 7 comments
Richard Foote wrote 9 months ago: In Updates and Indexes Part I, I described how there’s no such things as an “update … more →
Updates and Indexes Part I (Fashion)
— 23 comments
Richard Foote wrote 10 months ago: Let’s start with a few basic concepts. Simplistically, Oracle doesn’t generally care whe … more →
How To Rebuild And Make An Index Bigger, Not Smaller (Carry That Weight)
— 19 comments
Richard Foote wrote 10 months ago: I sometimes hear suggestions along the lines of: ”when you rebuild an index, at least you mak … more →
Deleted Index Entries Part IV (Breaking Glass)
— 2 comments
Richard Foote wrote 1 year ago: Yet another method of cleaning out deleted space Oracle has up its sleeve is the recycling of index … more →
Deleted Index Entries Part III (Slip Away)
— 5 comments
Richard Foote wrote 1 year ago: Another little post while I look after some unwell munchkins … I’ve already looked at th … more →
Deleted Index Entries - Part I (Let It Be)
— 9 comments
Richard Foote wrote 1 year ago: Just before I hop on a plane to do some training in Europe, thought I might begin a little series on … more →
Primary Keys and Non-Unique Indexes (What's Really Happening ?)
— 16 comments
Richard Foote wrote 1 year ago: Based on this OTN thread, it appears there may still be folk out there that think Oracle uses Unique … more →
Extended SQL Tracing Presentation (Your Possible Pasts)
— 3 comments
Richard Foote wrote 1 year ago: I’ve recently dug up an old presentation I did for the local Oracle User Group a number of yea … more →
Indexes and Sorts (Chant Of The Ever Circling Skeletal Family)
— 7 comments
Richard Foote wrote 1 year ago: In my previous post regarding Reading 100% of Data via an Index, one of the examples I described was … more →
Reading 100% of Data Via An Index (We Are Hungry Men)
— 12 comments
Richard Foote wrote 1 year ago: I’ve already previously discussed how a Full Table Scan can sometimes be the most effective ex … more →
Index Scan or Full Table Scan: The "Magic" Number (Magic Dance)
— 25 comments
Richard Foote wrote 1 year ago: What seems like ages ago, I listed 8 things you may not have known about indexes. Although I’v … more →
Indexes In Their Own Tablespace: Recoverability Advantages (Get Back)
— 5 comments
Richard Foote wrote 1 year ago: Thought I might share some thoughts regarding recoverability issues with regard to having indexes se … more →
Indexes In Their Own Tablespace: Availabilty Advantages (Is There Anybody Out There?)
— 17 comments
Richard Foote wrote 1 year ago: I’ve already discussed here some reasons why performance is not particularly improved by simpl … more →
Separate Indexes From Tables, Some Thoughts Part 1.5 (Think For Yourself)
— 5 comments
Richard Foote wrote 1 year ago: Based on the discussions on whether there’s any performance benefit in storing indexes separat … more →
Separate Indexes From Tables, Some Thoughts Part II (There There)
— 9 comments
Richard Foote wrote 1 year ago: In Part I, I discussed how separating indexes from tables won’t likely improve performance as: … more →
