--- 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.



Yes, I should have mentioned I'm using FB 2.1.4. I plan to move to 2.5 as soon
as a point release is released.


[Non-text portions of this message have been removed]