Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to avoid product join?? 1

Status
Not open for further replies.

madanjs

Programmer
Feb 6, 2011
2
US
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..
 
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.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top