How can we convert product join into a merge join?

Database
Enthusiast

How can we convert product join into a merge join?

When I take explain plan for a query....

it is showing that few joins r "PRODUCT JOINS"..because of this that qry is taking much time ..

So I want to convert into Merge Join...

How can I do this?

Your suggestions are really appriciated....
1 REPLY
SN
Enthusiast

Re: How can we convert product join into a merge join?

hi Ravindra,

try with primary indexes from the tables as the join column(s).

thx