Subject Re: [Firebird-general] OpenCRX DBMS comparison
Author Martijn Tonies
> >> > Given that a view can be used in conjunction with a very complex
> >> > additional query, I think that the plan should be recreated every
> >> > 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,
sub-optimal. :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions