RE: Bad exectution plans due to bind variable peeking

That's what I really did (method_opt=> 'FOR ALL COLUMNS SIZE 1') - I just consider that functionally the same as deleting them since it makes them show up as NONE in dba_tab_col_statistics.histogram, and technically 1 bucket can't qualify as an actual histogram.

Thanks,
Brandon

-----Original Message-----

From: Alex Gorbachev [mailto:gorbyx_at_gmail.com] Sent: Saturday, June 24, 2006 2:59 AM
To: Allen, Brandon
Cc: oracle-l_at_freelists.org
Subject: Re: Bad exectution plans due to bind variable peeking

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.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jun 26 2006 - 10:45:22 CDT