Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Statistics and Views
Only if you want it to use the cost based optimizer. It will still work
using the rule based optimizer without statistics but more than likely it
will be much slower.
"Epicentre team A" <oracle_at_epicentre.fr> wrote in message
news:agegqf$260$1_at_wanadoo.fr...
> HI
>
> I've a view 'Myview" on two tables T1 and T2.
> is it necessary to perform a full analyze on T1 and T2 for: SELECT * from
> Myview WHERE ...
> (Where clause is based on a cluster index ?)
>
> Thanks
>
>
Received on Tue Jul 09 2002 - 10:09:51 CDT