Lost your password?

Blogs about: Index Block Size

Featured Blog

Larger Block Tablespace For Indexes Revisited Part III (Prove Yourself)

Time to look a little at an Index Fast Full Scan (IFFS) with respect to moving indexes into a larger block tablespace. To start, a few points about an IFFS. When performing an IFFS, Oracle will read e… more →

Richard Foote's Oracle Blog

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 →

Tags: Index Height, Index Internals, Index Rebuild, Oracle Indexes, Oracle Myths

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 →

Tags: Index Height, Index Rebuild, Oracle Indexes, Oracle Myths

Larger Block Tablespace For Indexes Revisited: Part I (The Tourist) — 14 comments

Richard Foote wrote 10 months ago: I’ve previously discussed the various issues and myths relating to the so-called benefits of c … more →

Tags: Index Height, Oracle Indexes, Oracle Myths

Larger Block Index Tablespace and Small Index Scans - Performance Improvement ? (Let Down) — 10 comments

Richard Foote wrote 1 year ago: Thought it might be worth looking at the impact on the performance of Unique and small index range s … more →

Tags: Oracle General, Oracle Indexes, Oracle Myths, Performance Tuning, Tablespace Management

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 →

Tags: Oracle General, Oracle Indexes, Oracle Myths, Tablespace Management, Index Height, Index Internals

Store Indexes In A Larger Block Tablespace: The Multiblock Read Myth Part II (The Fly) — 67 comments

Richard Foote wrote 1 year ago: Thought I might begin by mentioning a lovely little story by Billy Verreynne in this OTN Forum Threa … more →

Tags: Oracle General, Oracle Indexes, Oracle Myths, Oracle Cost Based Optimizer, Index statistics, Performance Tuning, Tablespace Management

Store Indexes In A Larger Block Tablespace: The Multiblock Read Myth (Karma Police) — 6 comments

Richard Foote wrote 1 year ago: One of the great myths surrounding the use of differing block sizes is that storing indexes in large … more →

Tags: Oracle General, Oracle Indexes, Oracle Myths, Oracle Cost Based Optimizer, Index statistics, Performance Tuning, Tablespace Management

Store Indexes In a Larger Block Tablespace: Some Thoughts (Big Brother) — 17 comments

Richard Foote wrote 1 year ago: A suggestion that seems to pop up on a routine basis on various forums and discussion boards is that … more →

Tags: Oracle General, Oracle Indexes, Oracle Myths, Oracle Cost Based Optimizer, Richard's Musings, Performance Tuning, Tablespace Management


Have your say. Start a blog.

See our free features →

Related Tags
All →

Follow this tag via RSS