SQL Language (MOSC)

MOSC Banner

predicate is not pushed into view that uses an outer-join with a condition refering to attributes fr

edited Jun 29, 2013 12:50AM in SQL Language (MOSC) 6 commentsAnswered
Hello,

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center