2014-10-21 10:57 GMT-02:00 j...@jpm-cola.com:
Hi all,
I'm experimenting with table partitioning though inheritance. I'm testing
a query as follows:
explain (analyze, buffers)
select response.id
from claim.response
where response.account_id = 4766
and response.expire_timestamp is null
Danilo Mota [EMAIL PROTECTED] writes:
SELECT
rc.pkcliente
FROM r_cliente AS rc
INNER JOIN sav_cliente_lg AS sc ON sc.cpfcnpj = sc.cpfcnpj;
Surely you meant
INNER JOIN sav_cliente_lg AS sc ON rc.cpfcnpj = sc.cpfcnpj;
I would also venture that your statistics are desperately out of date,