Hey everyone,
On average, are multiple simple queries better performance-wise than joins?
i.e.
select A.col1 from table1 A
select B.col2 from table2 B where B.col1 = A.col1
etc
vs
select A.col1, B.col2 from table1 A, table2 B where B.col1 = A.col1
Are joins better for small/large numbers of tab
Anyone know of any visual modelling apps (like CA's ERWin ) that work well
with pg?
I Have been using erwin but just discovered it isn't creating my pk, fk or
unique constraints.
I am using the odbc v3.0 target repository option in erwin.
Thanks,
Morgan
---(end of bro
