Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Optimization Analysis question
Robert Chung wrote:
>
> The DBA_TABLES view in up-to-date version of Oracle databases show the
> date tables were analyzed in "LAST_ANALYZED" column, but Oracle
> database 7.3.4 does not. Does anyone know how to find out
> when/whether tables were analyzed in 7.3.4 version of database?
>
> Also, does RULE based optimization change path when table size
> changes? I know COST based optimization does that for sure. Thank
> you in advance.
Robert,
If your system has enough resources, why not just compute stats at the
schema level weekly via a DBMS_JOB?
Objects that change more frequently can be handled on a daily or
as-neede basis.
hth,
Paul Received on Sat Apr 14 2001 - 16:07:12 CDT