Where clause in views
626257Aug 19 2009 — edited Aug 19 2009Hi,
I have created a view as
create view V_new as Select call_date from T1 union all select transaction_date as call_date from T2 .
Now if I run a query as 'select * from V_new where call_date <=sysdate. How the query will execute ? Will it fetch all the date from both the tables, make union and then filter as per the where clause
OR
It will filter the data and then union the filtered data.
As per my understanding, it will select all data from underlying tables, union it and then filter as per the where.
Please update me if its not like this
Regards