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

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@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--