Re: Statistics and Views

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Tue, 9 Jul 2002 14:22:59 +0100
Message-ID: <UsBW8.825$zX3.763@news.indigo.ie>

No. The query will return the correct answer whether or not statistics are in place.

However it is not possible to say it will run optimally or even that it will run sub-optimally.

Statistics exist to allow Oracle to make better choices as to how it executes your queries, however barring a bug the correct set will be returned if they are not.
"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 - 08:22:59 CDT