Hi,

At May 11, 2005, 16:13, Dmitry Yemanov wrote:

> "Daniel Rail" <daniel@...> wrote:
>>
>> > Given that a view can be used in conjunction with a very complex
>> > additional query, I think that the plan should be recreated every time
>> > the view would be accessed.
>>
>> Totally agree.

> And this is how views are optimized for years.

Thanks for the insight. Obviously, Martijn and I didn't know that.

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