Hi,

At May 11, 2005, 08:59, Dmitry Yemanov wrote:

> "Daniel Rail" <daniel@...> wrote:
>>
>> Personally, I wouldn't mind seeing views being precompiled, just short
>> of going through the optimizer, because of the indices stats can
>> change with the amount of data. And, when the view is being
>> referenced, the optimizer would generate the plan at that time.

> I'm not sure I understand you. The access paths for the view internals are
> chosen when a view is referenced in the query.

I think I could me clearer. The views could be partially
prepared/compiled(at creation time), excluding the optimizer
processing. And, when the view is to be used, the optimizer would be
called to evaluate the plan to be used.

It's just my 2 cents.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)