How to avoid product join?? How to avoid product join?? madanjs (Programmer) (OP) 6 Feb 11 04:56 I am new to performance tuning...In the explain plan, i found that there is a product join,,How to avoid this?/ please help me out.. Thanks.. RE: How to avoid product join?? Gruuuu (Programmer) 11 Feb 11 14:54 Can you show your query? RE: How to avoid product join?? bkclaw113 (IS/IT--Management) 21 Jun 11 08:55 In general when your explain showes that you have a product join you have ommitted the join criteria between 2 tables, go back and examine your Where/On statements and make sure that the join criteria between each table is there.