--- In firebird-support@yahoogroups.com, Randall Sell <randallsell@...> wrote:
> I'm trying to sort out how to make my query as optimal as possible. And doing a
> fair amount of online reading in the process, but haven't found the definitive
> answer to a few Qs, so here goes...

...

> We never allow users to access tables directly. They always access views. For
> the sake of simplicity, let us say that there is a date column which is checked
> within the definition of the view:
>
> Create View MyView(.....)
> select * From MyTable
> where DateCol > [someDate]

One thing to check is the version of Firebird you are using. I may be corrected here but AFAIK v1.5 didn't always use the underlying indexes in views.

Tom