JL Computer Consultancy

Practical Oracle 8i - Building Efficient Databases

Chapter 6: Basic Indexing.


 Addenda

Histogram Buckets (10th Jan 2004)

 

Errata (updated 3rd Aug 2011)

 

Back to Book Index

 

Histogram Buckets (10th Jan 2004)

Page 90, start of second paragraph: “If you had analyzed the column to the maximum of 75 buckets,” the value 75 is the default number of buckets. The maximum is 254

Top of page.


Errata

Page 102, table 6-6: I define lf_rows as “number of current rows in the index (excluding deleted rows)”, similarly I defined lf_rows_len as “Total space requirement in bytes of leaf rows (excluding deleted rows)”. In both cases that should be including not excluding. i.e. the figures include the values for del_lf_rows and del_lf_rows_len.


Back to Book Index