pá 22. 11. 2019 v 19:42 odesílatel Luís Roberto Weck <
luisrobe...@siscobra.com.br> napsal:
> Em 22/11/2019 14:55, Pavel Stehule escreveu:
>
>
>
> pá 22. 11. 2019 v 18:37 odesílatel Luís Roberto Weck <
> luisrobe...@siscobra.com.br> napsal:
>
>> Hey,
>>
>> I'm trying to figure out why Postgres is
Em 22/11/2019 14:55, Pavel Stehule escreveu:
pá 22. 11. 2019 v 18:37 odesílatel Luís Roberto Weck
mailto:luisrobe...@siscobra.com.br>> napsal:
Hey,
I'm trying to figure out why Postgres is choosing a Hash Join
over a Nested Loop in this query:
SELECT T1.PesID, T1.PesN
pá 22. 11. 2019 v 18:37 odesílatel Luís Roberto Weck <
luisrobe...@siscobra.com.br> napsal:
> Hey,
>
> I'm trying to figure out why Postgres is choosing a Hash Join over a
> Nested Loop in this query:
>
> SELECT T1.PesID, T1.PesNom, T1.PesValSal, T1.PesCPFCNPJ, T2.CarAti,
> T1.CarCod, T1.EmpCod,
>
Hey,
I'm trying to figure out why Postgres is choosing a Hash Join over a
Nested Loop in this query:
SELECT T1.PesID, T1.PesNom, T1.PesValSal, T1.PesCPFCNPJ, T2.CarAti,
T1.CarCod, T1.EmpCod,
T2.CarFan, T1.PesDatAge, T1.PesCod, COALESCE( T3.PesDatAnt,
DATE '00010101') AS PesDatAnt
F
Hey,
I'm trying to figure out why Postgres is choosing a Hash Join over a
Nested Loop in this query:
SELECT T1.PesID, T1.PesNom, T1.PesValSal, T1.PesCPFCNPJ, T2.CarAti,
T1.CarCod, T1.EmpCod,
T2.CarFan, T1.PesDatAge, T1.PesCod, COALESCE( T3.PesDatAnt, DATE
'00010101') AS PesDatAnt
F
