-
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*
Thanks,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|