"Tao Ma" <[EMAIL PROTECTED]> writes:
> recently, I wrote a really complex SELECT statement which consists of about
> 20 relations using NATURAL JOIN method and every single relation consists 50
> columns. It looks like:
Maybe you should rethink your schema design...
> It seems Postgres cost lot
Hi,
recently, I wrote a really complex SELECT statement which consists of about
20 relations using NATURAL JOIN method and every single relation consists 50
columns. It looks like:
PREPARE ugly_stmt AS
SELECT * FROM t1 NATURAL JOIN t2 NATURAL JOIN t3 ... NATURAL JOIN t20 WHERE
id = $1;
All tab
