What do you understand by a Cartesian join?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

We get a Cartesian join by joining each row of a table with each row of some other table. It could also be obtained on joining each row of one table to each row of it only. This happens generally in the case when there are matching join columns not specified.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Abinitio Interview Questions

    What do you know about Abinitio?

    'Abinitio' is a word of Latin that is derived from 'ab' and 'initio' which in Latin means 'from' and 'beginning' respectively. So the word 'Abinitio' has its meaning as 'from the beginning'. It is a t...

    Abinitio Interview Questions

    How is the Partitioning With Key different from Round Robin Partition?

    Difference between Partition With Key and Round Robin Partition Partition With Key: Partition With Key is often also referred to as Hash Partition. This technology of partitioning is taken into use w...

    Abinitio Interview Questions

    Mention some ways for improving performance of a graph.

    There are lots of ways in order to improve the performance of a graph. It should be ensured that components are used in restrain amount in a specific phase. The optimum value of the highest Core value...