Originally posted by anandkl
So this a bug..it might a very serious effect on the database..
SO you suggest that using bind variable is the only safe solution.

Please suggest.


itīs not a bug, its side effects, with bind variables Oracle cant make good use of histograms, but if your queries query columns with uniform data distributions then you dont have to use histograms in that case you dont have to worry about this side effect