Re: A technical question about VIEWS

A view is effectively a dynamic filter. So under normal circumstances, if a view COULD select 10,000 rows in an open query, but you supply reduction criteria to select 10 rows, then this r4duction criteria will be 'passed through' the view and only 10 rows will be fetched.

Exceptions to this are aggregated views ( CREATE OR REPLACE VIEW V_ANYTHING AS SELECT acc_number, sum(balances)... GROUP BY acc_number ) and views where the reduction critera 'COLUMN1' is not a column on the underlying table ( e.g. SELECT column2||':'||column3 as column1 ).

Thus views are efficient for simple queries. Received on Fri Mar 28 1997 - 00:00:00 CST