Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Extremely slow querry

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... "

  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>&nbsp;</DIV>
<DIV><FONT size=3D2>Hi Siva,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT=20

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

size=3D2>dbms_utility.analyze_schema('SCHEMA_NAME'','COMPUTE',null,null,'= FOR ALL=20
INDEXES');</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>... will compute stats only for indexes which was =
the original=20
intent of the mail</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>U may wish to take a look&nbsp;in the manuals for=20
the&nbsp;</FONT><FONT size=3D2>ANALYZE TABLE command (to analyze indexes = of=20
particular table it's enough to=20
execute&nbsp;ANALYZE&nbsp;&nbsp;TABLE&nbsp;&nbsp;xxx&nbsp;COMPUTE&nbsp;ST= ATISTICS=20
FOR ALL INDEXES)&nbsp; </FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>hth,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>&nbsp;&nbsp;&nbsp; Marin</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>------------</DIV>
<DIV>&nbsp;</DIV>
<DIV>"And it comes to be that the soothing light at the end of your=20
tunnel<BR>&nbsp;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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US