Sean,

> I thought that with views (as currently implemented), any criteria/order
> specified with a view (SELECT ... FROM ViewA WHERE ViewColumn1 =
> 'Anything" ORDER BY ViewColumnB) was "merged" with the View definition
> to, in effect, become a single SELECT statement and hereby taking
> advantage of index and other performance optimizations.

haven't checked with the latest versions of IB, but I seem to remember
that it does not work this way (one of the reasons we here dropped views
in a big project).
I would be glad to know it's actually like you said.
--
____
_/\/ando