lucifer12346

Results 3 comments of lucifer12346

Scan and Join hints do not work as expected

However, using leading hint as follow does not correct the join order. ``` /*+ HashJoin(mc ct) HashJoin(mi_idx it) HashJoin(mi_idx it mc ct) NestLoop(mi_idx it mc ct t) IndexScan(t) SeqScan(mi_idx) SeqScan(it)...

Scan and Join hints do not work as expected

> > However, using leading hint as follow does not correct the join order. > > ``` > > /*+ > > HashJoin(mc ct) > > HashJoin(mi_idx it) > >...

Incorrect join order when using join method hints

I've encountered the same problem. Have you got any idea about how to fix it?