Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Activating / Rebuilding Statistics
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 - 10:04:36 CDT