Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Optimization Analysis question
to the second question. no it does not change
"Robert Chung" <robertch_at_mindspring.com> wrote in message
news:3ac5d070.13145952_at_198.99.146.10...
>
> 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.
>
>
Received on Mon Apr 16 2001 - 16:51:51 CDT