The Clustering Factor

The Clustering Factor

JL Computer Consultancy

Cost Based Oracle: Fundamentals

Chapter 5: The Clustering Factor

Ch.5 Code Depot(30th Dec 2005)

Addenda

Compactingtables (22nd Nov 2005)

Errata

Typos (10thFeb 2006)

ReverseKey indexes (22nd Nov 2005)

Addenda

Compacting tables (22ndNov 2005)

Page 112, heading Loose Ends: There is a discussion on Doug Burns’ blog about the point discussed in this section. Iwon’t comment on it further here, other than adding that if I can manageto squeeze it into the reprint, I shall change the last sentence of the finalparagraph to look something like:

“If you have used the technique discussed in the previous sectionfor correcting the effect ASSM hason the clustering_factor,then compacting tables may well nullify the effort …”

The URL for the blog entry is: http://oracledoug.blogspot.com/2005/11/another-interesting-lewis-tip.html

Back to Book Index

Top of page.

Errata

Typos (10th Feb 2006)

Page 100, 3rd para from end, firstline: “actually a just a low/high”should be “actually just a low/high”

Page 111, Section Informal Strategies, 2nd para:“you will see that the they have a”should be “you will see that theyhave a”

Reverse Key indexes (22nd Nov 2005)

Page 94, Paragraph 2: I said that reverse key indexes were introduced inOracle 8.1. In fact they appeared in 8.0.

Thanks to K Gopalakrishnan for spotting thiserror.

Back to Book Index

Top of page.