Subject Re: [firebird-support] Is it possible to have a view with parameters?
Author Milan Babuskov
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: