Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Optimizing inline view

Re: Optimizing inline view

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Wed, 08 Nov 2006 09:58:05 +0100
Message-ID: <4rdkguFqq41hU1@mid.individual.net>


On 07.11.2006 23:14, Mike C wrote:
> I was under the impression that when you created an
> index it compilied the statistics for that index. That is obviously not
> the case. Thanks for your help.

IMHO this is version dependend. It seems that Ora 10 does it automatically but not older versions:

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5010.htm#sthref6625

Kind regards

        robert Received on Wed Nov 08 2006 - 02:58:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US