Subject Indexed Views
Author donjules2k
Are there any plans to add indexed / materalized view? These add an
amazing performance gain and with SQL Server they are only available
in enterprise edition which means $20,000. I think this would be a
great asset for firebird. Any thoughts?


Original messages from support list:

>Does firebird support the Oracle / SQL Server idea of indexed views?
>If so how?

If you are talking about "materialized views" then No. A regular view will
use the table indexes if the underlying SELECT specification would use