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!

Register Log in
  • Congratulations SkipVought 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

madanjs

Programmer
Feb 6, 2011
2
0
0
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..
 
Sort by date Sort by votes
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.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teamalone
  • Locked
  • Question
How to export multiple files using teradata tpt
Replies
0
Views
84
Teamalone
Teamalone
multipledatabases
  • Locked
  • Question
How to bulk import a CSV or a TXT file trough command into a Teradata database
Replies
1
Views
132
Miguel93
Miguel93
Samm2020
  • Locked
  • Question
Oracle to Teradata for data source setup
Replies
1
Views
86
johnherman
johnherman
peac3
  • Locked
  • Question
Dynamic Join help please... tough query
Replies
0
Views
48
peac3
peac3
tmcrouse
  • Locked
  • Question
tough time with a teradata date format
Replies
0
Views
60
tmcrouse
tmcrouse

Part and Inventory Search

Sponsor

Back
Top