Select rows

[Ronein]

Both are done via proc sql( inner join and Cartesian product.
As I understand you say that Cartesian product is more efficient( using where )?

[Kurt_Bremser]

---

@Ronein wrote:
Both are done via proc sql( inner join and Cartesian product.
As I understand you say that Cartesian product is more efficient( using where )?

---

No. What is more efficient is best determined by testing (see Maxim 4).

It is just that our database coders prefer to use the cartesian + WHERE, for whatever reason.