Re: Activating / Rebuilding Statistics
From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Tue, 26 Aug 2003 08:04:36 -0700
Message-ID: <3F4B7704.FE07E8E7_at_exxesolutions.com>
Date: Tue, 26 Aug 2003 08:04:36 -0700
Message-ID: <3F4B7704.FE07E8E7_at_exxesolutions.com>
Mark D Powell wrote:
> Marc Eggenberger <marc.eggenberger_at_itc.alstom.com> wrote in message news:<MPG.19b52d39a0b26d819896d0_at_iww.cacti.ch.alstom.com>...
> > In article <3F4AA9AF.5290B99C_at_exxesolutions.com>,
> > damorgan_at_exxesolutions.com says...
> >
> > [...]
> >
> > > SELECT max(last_ddl_date)
> > > FROM user_objects;
> >
> > Isn't it
> > SELECT max(last_ddl_time) from user_objects;
> > ?
>
> Daniel, Mark, what does last_ddl_time have to do with statistics?
Nothing. Last analyzed in all_tables and all_indexes if that is the question.
-- 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 - 17:04:36 CEST