sql - Performance of Inner Join vs Cartesian product -
possible duplicate:
explicit vs implicit sql joins
i want know difference in performance of
select * a,b,c a.x = b.y , b.y = c.z
and
select * inner join b on a.x = b.y inner join c on b.y = c.z
basically want know if inner join performs better cartesian product? also, in inner join cartesian product carried out internally?
first of these 2 operations 2 different purposes , while cartesian product provides result made joining each row 1 table each row in table. while inner join (sometimes called simple join ) join of 2 or more tables returns rows satisfy join condition.
now coming have written here :
in case of cartesian product first table comprising of a,b,c created , after on basis of ever condition given,we result. see it's heavy process.
on other hand inner join chooses result fulfilling given condition .hence it's better solution achieving end results.
first 1 abuse of sql language.
wiki
Comments
Post a Comment