Suppose I have a defined on two tables Tab1 and Tab2 as
CREATE VIEW VIEW1 AS
SELECT T1.COL1, T1,COL2, T1.COL3 FROM TAB1 T1, TAB2 T2
WHERE T1.COL1 = T2.COL2
AND, I have a query like the following.
SELECT V.* FROM VIEW1 V WHERE V.COL1 = 10 ;
I have index on COL1 of TAB1 and TAB2.
When I do the above query, I believe Oracle retrieves the result from the view after applying the where condition in 8.1.6. Could anyone tell me whether this is the cas with Oracle always irrespective of the version?
*I was under the impression, in the prev versions (pre 8.1.5) oracle executes the View first then applies the where condition on the result set*
Click Here to Expand Forum to Full Width