A Cartesian join is used when one or more of the tables do not have any join conditions. Optimizer joins every row from one data source with every row from the other data source.