Subject Re: [firebird-support] Creating INDEXes on a VIEW
Author Brian L. Juergensmeyer
Hi, Martijn

The big concern that we would have would be to ensure that any query made
against a view (rather than a table) still return relatively quickly. On
some of our tables, this requires careful indexing. Maybe we're not
thinking properly and should just create a new VIEW that uses a different
index if it is critical to return as quickly as possible from the query.

Am I thinking correctly now?

Thanks everyone for your help,