Subject Re: [firebird-support] Views and where clauses
Author Arno Brinkman

> First a simple question - are views capable of using indexes when
> selected from with a where clause?

> The view would be defined as such:
> Create view A_Max (Column1, column2, column3, max_create_date) as
> select
> column1, column2, column3, max(created_date)
> from
> a
> group by
> column1, column2, column3;

Views that contain aggregates and unions cannot use a where clause from the
For a "aggregate view" the where clause is going into the having clause,
because you could be filtering on a aggregate function (or expression which
contains it).

Arno Brinkman

Firebird open source database (based on IB-OE) with many SQL-99 features :

Support list for Interbase and Firebird users :

Nederlandse firebird nieuwsgroep :