predicate is not pushed into view that uses an outer-join with a condition refering to attributes fr
I'm just struggeling with a quite complex statement that uses a join with a view and does not push a predicate into it, but instead builds the whole view and filters according to the predicate later. To make things simpler I creted a small reproducable testcase that shows the issue:
--Create three simple tables with indexed ids
create table testtab1 as select level id, level id1, 'F1' f from dual connect by level <= 100000;
create index idx_testtab1 on testtab1(id);
create table testtab2 as select level id, 'F2' f from dual connect by level <= 50000;
create index idx_testtab2 on testtab2(id) tablespace users;