RE: Which one is good in terms of performance

Well, if you were to read any docs, you would see that dbms_stats is the = prefered method for gathering schema stats. As afr as the options you = have specified, you will need to read up to see if these fit, as you = have provided no information on your hardware, database, etc.

--

Ron Reidy
Lead DBA
Array BioPharma, Inc.

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

From:	oracle-l-bounce_at_freelists.org on behalf of Seema Singh
Sent:	Thu 12/23/2004 1:05 PM
To:	oracle-l_at_freelists.org
Cc:=09
Subject:	Which one is good in terms of performance

1)
exec dbms_stats.gather_schema_stats(ownname =3D>'''||username|| ''',degree=3D>4,cascade =3D>TRUE,options=3D>''GATHER STALE''); 2)DBMS_UTILITY.ANALYZE_SCHEMA('USERNAME','COMPUTE'); 3)ANALYZE TABLE <TABLENAME> COMPUTE STATTISTICS FOR ALL INDEXES COLUMNS; Please suggest which is best in case of cost based optimizer in = Oracle9i.
thanks

--

http://www.freelists.org/webpage/oracle-l

This electronic message transmission is a PRIVATE communication which = contains
information which may be confidential or privileged. The information is = intended=20
to be for the use of the individual or entity named above. If you are = not the=20
intended recipient, please be aware that any disclosure, copying, = distribution=20
or use of the contents of this information is prohibited. Please notify = the
sender of the delivery error by replying to this message, or notify us = by
telephone (877-633-2436, ext. 0), and then delete it from your system.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 23 2004 - 14:15:37 CST