Existe grande diferença de desempenho entre estas duas querys ?
SELECT "agreementStatus_id", "agreementStatus_name"
FROM (
SELECT "agreementStatus"."id" AS "agreementStatus_id",
"agreementStatus"."name" AS "agreementStatus_name",
* ... mais 40 colunas*
FROM "rental"."agreementStatus"
) AS "subQuery"
SELECT "subQuery".*
FROM (
SELECT "agreementStatus"."id" AS "agreementStatus_id",
"agreementStatus"."name" AS "agreementStatus_name"
FROM "rental"."agreementStatus"
) AS "subQuery"
--
Kévio Castro
(62) 9959-6192
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
