Re: Extremely slow querry

From: Marin Dimitrov <marin_at_sirma.bg>
Date: Fri, 4 Aug 2000 10:40:46 +0300
Message-Id: <10579.113822@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: Extremely slow querry</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV> </DIV>
<DIV><FONT size=3D2>Hi Siva,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT=20

size=3D2>dbms_utility.analyze_schema('SCHEMA_NAME','COMPUTE');</FONT></DI= V>
<DIV> </DIV>
<DIV><FONT size=3D2>... will compute the stats for tables, indexes and =
columns in=20
the schema while </FONT></DIV>
<DIV> </DIV>
<DIV><FONT=20

size=3D2>dbms_utility.analyze_schema('SCHEMA_NAME'','COMPUTE',null,null,'= FOR ALL=20
INDEXES');</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>... will compute stats only for indexes which was =
the original=20
intent of the mail</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>U may wish to take a look in the manuals for=20
the </FONT><FONT size=3D2>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)  </FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>hth,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>    Marin</FONT></DIV>
<DIV> </DIV>
<DIV>------------</DIV>
<DIV> </DIV>
<DIV>"And it comes to be that the soothing light at the end of your=20
tunnel<BR> is just a freight train coming your way... "<BR></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:Siva_Chintalapati_at_satyam.com"=20   title=3DSiva_Chintalapati_at_satyam.com>Siva_Chintalapati</A> </DIV>   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, August 04, 2000 = 09:34</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: Extremely slow = querry</DIV>
  <DIV><BR></DIV>
  <P><FONT color=3D#0000ff face=3DArial size=3D2>Hello ,</FONT> =
<BR><FONT=20

  color=3D#0000ff face=3DArial size=3D2>Please say me how to compute and = estimate=20
  stastics.</FONT> </P> Received on Fri Aug 04 2000 - 02:40:46 CDT