"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.


Dmitry