Message-Id: <10579.113822@fatcity.com> From: "Marin Dimitrov" Date: Fri, 4 Aug 2000 10:40:46 +0300 Subject: Re: Extremely slow querry This is a multi-part message in MIME format. ------=_NextPart_000_007C_01BFFE00.725B62B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Extremely slow querry Hi Siva, dbms_utility.analyze_schema('SCHEMA_NAME','COMPUTE'); ... will compute the stats for tables, indexes and columns in the schema = while=20 dbms_utility.analyze_schema('SCHEMA_NAME'','COMPUTE',null,null,'FOR ALL = INDEXES'); ... will compute stats only for indexes which was the original intent of = the mail U may wish to take a look in the manuals for the ANALYZE TABLE command = (to analyze indexes of particular table it's enough to execute ANALYZE = TABLE xxx COMPUTE STATISTICS FOR ALL INDEXES) =20 hth, Marin ------------ "And it comes to be that the soothing light at the end of your tunnel is just a freight train coming your way... " ----- Original Message -----=20 From: Siva_Chintalapati=20 To: Multiple recipients of list ORACLE-L=20 Sent: Friday, August 04, 2000 09:34 Subject: RE: Extremely slow querry Hello ,=20 Please say me how to compute and estimate stastics.=20 ------=_NextPart_000_007C_01BFFE00.725B62B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Extremely slow querry
 
Hi Siva,
 
dbms_utility.analyze_schema('SCHEMA_NAME','COMPUTE');
 
... will compute the stats for tables, indexes and = columns in=20 the schema while
 
dbms_utility.analyze_schema('SCHEMA_NAME'','COMPUTE',null,null,'= FOR ALL=20 INDEXES');
 
... will compute stats only for indexes which was = the original=20 intent of the mail
 
U may wish to take a look in the manuals for=20 the ANALYZE TABLE command (to analyze indexes = of=20 particular table it's enough to=20 execute ANALYZE  TABLE  xxx COMPUTE ST= ATISTICS=20 FOR ALL INDEXES) 
 
hth,
 
    Marin
 
------------
 
"And it comes to be that the soothing light at the end of your=20 tunnel
 is just a freight train coming your way... "
----- Original Message -----
From:=20 Siva_Chintalapati
To: Multiple recipients of list ORACLE-L =
Sent: Friday, August 04, 2000 = 09:34
Subject: RE: Extremely slow = querry

Hello , =
Please say me how to compute and = estimate=20 stastics.