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: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Fri, 4 Aug 2000 08:50:35 -0700 (PDT)
Message-Id: <10579.113870@fatcity.com>


--0-1804289383-965404235=:4470
Content-Type: text/plain; charset=us-ascii

 Actually this will NOT compute stats for columns - just tables and indexes. If you want stats on columns you must include them specifically. For example

dbms_utility.analyze_schema('schema_name','compute',NULL,NULL,'for tables for indexes for all indexed columns');

  Marin Dimitrov <marin_at_sirma.bg> wrote: Hi Siva,dbms_utility.analyze_schema('SCHEMA_NAME','COMPUTE'); ... will compute the stats for tables, indexes and columns in the schema while



Do You Yahoo!?
Kick off your party with Yahoo! Invites. --0-1804289383-965404235=:4470
Content-Type: text/html; charset=us-ascii

<P> Actually this will NOT compute stats for columns - just tables and indexes. If you want stats on columns you must include them specifically. For example</P>
<P>dbms_utility.analyze_schema('schema_name','compute',NULL,NULL,'for tables for indexes for all indexed columns');<BR></P>
<P>&nbsp; <B><I>Marin Dimitrov &lt;marin_at_sirma.bg&gt;</I></B> wrote: <BR>
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<DIV><FONT size=2>Hi Siva,</FONT></DIV>
<DIV><FONT size=2>dbms_utility.analyze_schema('SCHEMA_NAME','COMPUTE');</FONT></DIV><BR>
<DIV><FONT size=2>... will compute the stats for tables, indexes and columns in the schema while </FONT></DIV></BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>
Kick off your party with Yahoo! Invites. --0-1804289383-965404235=:4470-- Received on Fri Aug 04 2000 - 10:50:35 CDT

Original text of this message

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