Subject Re: [Firebird-general] View uses table index?
Author Christian G├╝tter
Hi Bob,

> I want to create a view that performs a join between a master
> and detail
> table in order to provide a total column.
> If I select from this view, will the indices from the
> underlying tables be
> used?

This list is not for support questions. Please ask support
questions at the IB-Support list (also at Yahoogroups).

And yes, AFAIK indices are used when you select from a
view. (But it is always a good idea too look at the query
plan. Interbase 6.x and earlier Firebird versions have a
bug which sometimes occurs when you join a table and a
view. Then the index is ignored. I once stumbled over this