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

I did know that :-)

I also know that the optimizing of a statement that included a view is,
well,
sub-optimal. :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com