Guess what Chris, ... I have saved the stats and there are less than 10% of the rows where there is any difference in the stats in various columns. Most of the time, the difference is about less than 5%.
Is that good enough to throw off the optimizer?? Thanks Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -----Original Message----- Sent: Thursday, August 08, 2002 3:38 PM To: 'Jamadagni, Rajendra'; '[EMAIL PROTECTED]' Raj, (scratching my head) I haven't really thought about this (actually I dont think, too old), but I believe NULL would be considered a "value" and therefore the default doesn't kick in. Don't know, perhaps someone else can confirm/deny this. If true then I would recode the procedure call to specify the parameters with the values...OWNER=>cRec.owner. Or something like that, my brain is getting lots of memory faults at the moment. Otherwise, I would be studying the stats dbms_stats is generating, you know basic stuff. Like do the tables and indexes have stats?? Or save off the stats from dbms_stats and compare them to the stats you get from ANALYZE_SCHEMA. Or copy the schema over, generate the stats the other way and do some cool SQL comparing the stats. You got to pull out your red shovel and your yellow pail and play, have some fun. HTH. Chris Crawling back into my padded cube.
*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
