Originally posted by anandkl
I am trying to understand, if histograms are being generated will it improve the selectivity.
it will not improve the selectivity, but will giv better picture of the selectivity ( ofcourse i am talking about low card columns )

And its useless if Binds are used..


Originally posted by anandkl
I know that selecting > 10-20% of the total records will definitly do a FTS

regards
anandkl
its not Records but Blocks, ofcourse no of recs with clustering factor playing a significant role.. in decision making

Abhay.