March 06, 2006

Cost Based Oracle

4 out of 5 stars

I began to read this book. I attended several presentations by this book’s author,Johnathan Lewis, in UKOUG conference and some were quite impressive.
This book is definitely a dream-killer. I cannot fall asleep after reading this, for you have to be very vigilant. I brought this book back to office.

P101: Columns order: put columns that appear with a range-based predicate toward the end of index definition; improve the compressibility of an index by putting the least selective(most repetitive) columns first

P69 Index-driven access path:
 cost  = blevel + 
            leaf_blocks * effective_index_selectivity +
           clustering_factor * effective_table_selectivity

effective_index_selectivity MIGHT = 1/distinct_keys (in user_indexes table)

P52 selectivity = “required range”divided by “total available range”

- No comments Not publicly viewable

Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

Search this blog

Search Warwick Blogs



Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder