Re: Bad exectution plans due to bind variable peeking
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- Date: Sat, 24 Jun 2006 11:58:51 +0200
Actually, you might want to collect them with size 1 instead of
deleting completely. This way Oracle has better chances to guesstimate
cardinality of the columns.
2006/6/24, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx>:
Deleting the histograms did the trick! Thanks Alex!
--
Best regards,
Alex Gorbachev
http://blog.oracloid.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
