Blogs about: Oracle Indexes
An Index Only Performs How Much Work ???
— 20 comments
Richard Foote wrote 1 week ago: One of the main reasons suggested for performing periodic index rebuilds is to improve “perfor … more →
Rebuilding Indexes Every Sunday Afternoon !!
— 52 comments
Richard Foote wrote 3 weeks ago: I just had to share this amusing article on “Scheduling Oracle Index Rebuilding“. Regula … more →
The CBO CPU Costing Model and Indexes - Another Introduction
— 10 comments
Richard Foote wrote 2 months ago: I’ve previously discussed some basic concepts and formulas regarding how the CBO derives index … more →
OPTIMIZER_INDEX_CACHING Parameter
— 7 comments
Richard Foote wrote 2 months ago: As previously discussed, the CBO assumes the actual costs and overheads associated with all I/Os to … more →
The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part III
— 7 comments
Richard Foote wrote 3 months ago: After a bit of a layoff to organise a few upcoming overseas trips, while watching plenty of Ashes Cr … more →
Upcoming Index Internals and Best Practices Seminar Dates
Richard Foote wrote 3 months ago: I have a number of upcoming dates for my “Index Internals And Index Internals” 2 Day Sem … more →
The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part II
— 10 comments
Richard Foote wrote 4 months ago: In OPTIMIZER_INDEX_COST_ADJ Part I, I discussed how this parameter can significantly impact the ove … more →
Index Quizzes With Jonathan Lewis (Talk Show Host)
Richard Foote wrote 4 months ago: I’ve recently looked at some really atrocious Oracle related articles that are out there to co … more →
How To Really Create A Function-Based Index (A Day In The Life)
— 15 comments
Richard Foote wrote 4 months ago: “I heard the news today, oh boy” (John Lennon 1967). It was with some amusement that som … more →
The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part I
— 16 comments
Richard Foote wrote 4 months ago: In the previous entry regarding The CBO and Indexes, we saw how the CBO with a query that selected 5 … more →
The CBO and Indexes: Introduction Continues ...
— 9 comments
Richard Foote wrote 5 months ago: OK, I previously briefly covered how the CBO calculates the basic cost of an index range scan. Yes, … more →
The CBO and Indexes: An Introduction (Absolute Beginners)
— 15 comments
Richard Foote wrote 5 months ago: One of the more common questions I get asked and one of the most common questions asked in the vario … more →
Indexes And Small tables Part VII (Cluster One)
— 14 comments
Richard Foote wrote 6 months ago: OK, almost getting to the end here As discussed previously, despite popular opinion, an index can be … more →
Two Excellent Index Related Blog Posts
Richard Foote wrote 6 months ago: Before I sit down and write something new, thought I might quickly mention two excellent recent inde … more →
Indexes And Small Tables Part VI (Loaded)
— 9 comments
Richard Foote wrote 6 months ago: Thanks to comments by PdV, I need yet another Part before I can look at completing this series OK, w … more →
Indexes And Small Tables Part V (It's No Game)
— 10 comments
Richard Foote wrote 6 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 6 months ago: As I asked in my previous post, the key question when comparing the associated costs of accessing a … more →
Indexes On Small Tables Part III (Another Brick In The Wall Part III)
— 7 comments
Richard Foote wrote 6 months ago: So far, in Part I and Part II of this little series, we’ve looked at how Oracle performs a Ful … more →
Indexes On Small Tables Part II (The Mysteries)
— 12 comments
Richard Foote wrote 7 months ago: I’m a bit pushed for time at the moment but I thought I might quickly just expand a little on … more →
