Implicit Passing of "Parameters" to Views

I have a view set up like...

Create View View1 as
Select A.field1,A.field2,sum(A.field3)
From

    Table1 A

I now want to issue a select statement on this view similar to the following...

Select * from View1 where field2 = 'PARAMETER'

and have the underlying view1 know to restrict the query to only those records where field2='Parameter'. All of my experimentation seems to prove that Oracle creates a temporary table of all possible values first, and then restricts the rows in the temporary table to those meeting the condition. Since this is a very large table, it is very inefficient.

Any help would be appreciated. I am using Oracle 7.3.

Tim Theis
ttheis_at_dytn.veridian.com Received on Mon Aug 30 1999 - 14:00:01 CDT