PenWin wrote:

> That's an answer to a different question, though. Parametrized VIEWs do
> have their uses and can be very useful in specific cases. Using WHERE
> clauses on completed views may achieve the same result, but often at a
> serious performance cost

This has been (mostly) fixed in Firebird 2.1. If you use WHERE clause on
view with UNIONed tables, it can use indexes on underlying tables.


--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================