Subject | Re: [firebird-support] Creating INDEXes on a VIEW |
---|---|
Author | Brian L. Juergensmeyer |
Post date | 2003-07-31T20:28:19Z |
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,
Brian
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,
Brian