THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!

Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

Code Block

// an exception that the v2 is not existent will be thrown 
select /*+ BROADCAST(v2t1) */ t1.a
from (select * from test1) t1 join test2
on t1.a = test2.a

// use the equivalent sql following
create view t1 as select * from test1;
select /*+ BROADCAST(v2t1) */ t1.a
from t1 join test2 on t1.a = test2.a

...