Oracle-L: RE: Statistics - using dbms

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Thu, 08 Aug 2002 12:56:31 -0800
Message-ID: <F001.004AFBF6.20020808125631@fatcity.com>

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'; 'ORACLE-L_at_fatcity.com'

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.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).



text/plain attachment: InterScan_Disclaimer.txt

Received on Thu Aug 08 2002 - 15:56:31 CDT

RE: Statistics - using dbms_stats breaks the query