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

Popular posts from this blog

Asterisk AGI Python Script to Dialplan does not work -

python - Read npy file directly from S3 StreamingBody -

kotlin - Out-projected type in generic interface prohibits the use of metod with generic parameter -