JL Computer Consultancy

Cost Based Oracle: Fundamentals

Chapter 5: The Clustering Factor


Ch.5 Code Depot (30th Dec 2005)

Addenda

Compacting tables (22nd Nov 2005)

Errata

Typos (10th Feb 2006)

Reverse Key indexes (22nd Nov 2005)

Addenda

Compacting tables (22nd Nov 2005)

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

“If you have used the technique discussed in the previous section for correcting the effect ASSM has on 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, first line: “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 they have a”

Reverse Key indexes (22nd Nov 2005)

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

Thanks to K Gopalakrishnan for spotting this error.

 


Back to Book Index

Top of page.