That is a very nice and accurate analysis. Allowing the CBO to make a more accurate cardinality estimates is what histograms are all about. That may have the consequence that the CBO chooses an index access path if a suitable index is available, but that is by no means the only possible consequence. Seeing histograms only in connection with an index is seeing it too narrowly.
PS. the testcase is in the paper 'Histograms - Myths and Facts" on my website. At 11:41 AM 11/20/2006, Allen, Brandon wrote:
I'm curious to see the example too. My guess is that the histograms made a difference in the CBO's cardinality estimate, which in turn caused it to choose a different join method or join order.
Regards Wolfgang Breitling Centrex Consulting Corporationwww.centrexcc.com
______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System.For more information please visit http://www.messagelabs.com/email ______________________________________________________________________