Re: Activating / Rebuilding Statistics
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 25 Aug 2003 17:37:50 -0700
Message-ID: <2687bb95.0308251637.39685527_at_posting.google.com>
Date: 25 Aug 2003 17:37:50 -0700
Message-ID: <2687bb95.0308251637.39685527_at_posting.google.com>
"Sha" <ssha53_at_singnet.com.sg> wrote in message news:<bie1jv$rtk$1_at_reader01.singnet.com.sg>...
> Hi
>
> We are running Oracle v 8.1.7.
> Can someone kindly tell me how to check/activate if the statistics for the
> tables are turned on ?
>
> Thanks in advance.
To turn on statistics you must first generate them using either the analyze command or the dbms_stats package.
You can tell when statistics were last generated for an object by looking at the last_analyzed date column in dba_tables and dba_indexes.
See the Concepts manual for a general discussion. DBMS_STATS is documented in the Oracle Supplied Packages manual Analyze is documented in the SQL manual
HTH -- Mark D Powell -- Received on Tue Aug 26 2003 - 02:37:50 CEST