Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help on Oracle statistics/runstat
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