answersLogoWhite

0


Best Answer

A Cartesian join is when you join every row of one table to every row of another table. While on occassion this may be needed I would argue that a properly constructred database would negate this. This is in fact a VERY hard hitting operation on your resources and should be avoided at any cost. A normal join will include the comparison of one or two fields between tables. While you want to limit the number of joins you have in a query a properly constructed join is not a big use on resources. This of course takes into consideration proper indexing and database construct.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the difference between cartisean product and natural join operation?
Write your answer...
Submit
Still have questions?
magnify glass
imp