> I am in the impression that SQL join takes more time for
> execution as well as space because database internally builds Cartesian
> product and then evaluates for condition.
No, that's a conceptual description, but the actual process is more
optimized, often far more so if you have the appropri
Can anybody please tell me whether there are any disadvantage of SQL
joins in terms of space and time and how postgres has implemented SQL
joins? I am in the impression that SQL join takes more time for
execution as well as space because database internally builds Cartesian
product and then eva
