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

Home -> Community -> Usenet -> c.d.o.server -> Re: Help on Oracle statistics/runstat

Re: Help on Oracle statistics/runstat

From: <michael_bialik_at_my-deja.com>
Date: Fri, 22 Oct 1999 22:52:28 GMT
Message-ID: <7uqprc$l2a$1@nnrp1.deja.com>


Hi.

 Look at :

 ANALYZE TABLE <tab_name> COMPUTE STATISTICS ...

 Are all your tables are analyzed??

 ANALYZE command causes Oracle to use COST BASED OPTIMIZER  instead of default RULE BASED and it must be all tables or  not a single one of them.

 Execute
 SELECT table_name, num_rows FROM USER_TABLES.  If you see any values in num_rows column - you are using CBO.

 HTH. Michael.

In article <7upkrk$p8l$1_at_nnrp1.deja.com>,   raju_pillai_at_yahoo.com wrote:
> Folks, I created a table and an index for the table then I loaded
about
> 200K rows. Even though the index was active when I loaded the data I
> rebuild the index using ALTER INDEX xxx rebuild; , the statistics
> does'nt show anything. May be I am looking at the wrong place.
> Whats the job or command I should run to update the statistics or
> catalogs of the table and indexes and where should I look for the
> statistics.
>
> Any input is appreciated. Thanks in adavance.
>
> Raju
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 22 1999 - 17:52:28 CDT

Original text of this message

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