I have two tables in different schemas..
scott.emp and ford.emp

I have another third schema called turner..
Created a union all view in turner schema as follows

create view turner.emp as
select empno,ename from scott.emp
union all
select empno,ename from ford.emp;


Now whenever I run any large queries against this union all view (turner.emp) , it does not use the indexes..It does a full table scan on the underlying tables (scott.emp and turner.emp)..

For the same query if I use the table instead of the view indexes are used..

Each table has about 2 million of rows..

Please help

thanks

sami