Monday, July 21, 2008

Ask Tom first

Oracle histogram statistics helps CBO to choose the right/best execution plan for the SQL. There are plenty of articles on it in the net and most of deals with it really deep. And of course the authoritative one is the Oracle Ref Guide . So I was planning to write a blog entry with simple example to explain histograms. Ok, then I thought let me quickly search asktom and make sure it don't have similar entry .. and hola ...there was this discussion on histogram ... much better and simpler ....boy .....that site is the best .....

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:707586567563

I decided to look at that site first for all my Oracle database problems .....