Blogs about: Index Internals
Featured Blog
Indexes And Small Tables Part V (It's No Game)
So far in our little example, we’ve looked at how accessing a row of a one block table via a FTS required 4 consistent gets while accessing this same table via a Non-unique index reduced the con… more →
Richard Foote's Oracle Blog
Indexes And Small Tables Part V (It's No Game)
— 10 comments
Richard Foote wrote 7 months ago: So far in our little example, we’ve looked at how accessing a row of a one block table via a F … more →
Indexes And Small Tables Part IV (Treefingers)
— 13 comments
Richard Foote wrote 7 months ago: As I asked in my previous post, the key question when comparing the associated costs of accessing a … more →
Differences Between Unique and Non-Unique Indexes Part 4.5 (Fix You)
— 4 comments
Richard Foote wrote 8 months ago: In my last post, Part IV in this series, we looked at how a Unique Index can reuse space deleted wit … more →
Differences Between Unique and Non-Unique Indexes Part IV (Take It Back)
— 9 comments
Richard Foote wrote 8 months ago: I’ve previously discussed various differences between Unique and Non-Unique indexes (Part I, P … 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 →
Store Indexes In A Larger Block Tablespace: Height Reduction 1/2 Myth (Five Foot One)
— 14 comments
Richard Foote wrote 1 year ago: A common misconception with using a larger block tablespace specifically for indexes is that this wi … more →
Index Compression Part IV (Packt Like Sardines In a Crushd Tin Box)
— 9 comments
Richard Foote wrote 1 year ago: A great question by Brian Tkatch has convinced me there needs to be at least a Part IV in this parti … more →
Index Compression Part III (2+2=5)
Richard Foote wrote 1 year ago: As previously discussed, compression is only beneficial when the compressed columns have repeated va … more →
It's Less Efficient To Have Low Cardinality Leading Columns In An Index (Right) ?
— 11 comments
Richard Foote wrote 1 year ago: A common myth or mis-perception is that when deciding how to order the columns in a concatenated, mu … more →
How Are NULLs Actually Indexed ? (Fascination)
— 12 comments
Richard Foote wrote 1 year ago: A nice question by Jeff regarding how Oracle goes about indexing NULLs has prompted me to show how o … more →
Introduction To Reverse Key Indexes: Part III (A Space Oddity)
— 11 comments
Richard Foote wrote 1 year ago: A possibly significant difference between a Reverse and a Non-Reverse index is the manner in which s … more →
Differences between Unique and Non-Unique Indexes (Part III)
— 3 comments
Richard Foote wrote 1 year ago: A comment by Robert in Part II of this series reminded me of another subtle difference between Uniqu … more →
Differences between Unique and Non-Unique Indexes (Part II)
— 18 comments
Richard Foote wrote 1 year ago: The most significant difference between a Unique and a Non-Unique index is of course the simple fact … more →
Do ROWID Index Row Entry Columns Impact Index Block Splits ?
— 6 comments
Richard Foote wrote 1 year ago: Based on a great question by Alberto Dell’Era in my “Differences Between Unique/Non-Uni … more →
Differences between Unique and Non-Unique Indexes (Part I)
— 21 comments
Richard Foote wrote 1 year ago: I’ve had a number of comments regarding my earlier blog entry where I recommended avoiding Def … more →
Constraints - Don't make them DEFERRABLE or NOVALIDATE unless you need to.
— 21 comments
Richard Foote wrote 1 year ago: Back when Oracle8 was released, Oracle introduced a number of new features with regard to constraint … more →
Index Internals - Rebuilding The Truth
— 7 comments
Richard Foote wrote 2 years ago: The issue of when to rebuild indexes crops up again and again and again. Unfortunately, so do the sa … more →
