Help on Oracle statistics/runstat

From: <raju_pillai_at_yahoo.com>
Date: Fri, 22 Oct 1999 12:21:10 GMT
Message-ID: <7upkrk$p8l$1@nnrp1.deja.com>

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. Received on Fri Oct 22 1999 - 07:21:10 CDT