Re: Activating / Rebuilding Statistics
From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Mon, 25 Aug 2003 17:28:31 -0700
Message-ID: <3F4AA9AF.5290B99C_at_exxesolutions.com>
Date: Mon, 25 Aug 2003 17:28:31 -0700
Message-ID: <3F4AA9AF.5290B99C_at_exxesolutions.com>
Sha wrote:
> 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.
[Quoted] SELECT max(last_ddl_date)
FROM user_objects;
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Tue Aug 26 2003 - 02:28:31 CEST