Em sáb, 11 de jul de 2020 às 14:20, <luis.robe...@siscobra.com.br> escreveu:
> Hi! > > Recently on a blogpost [1] I saw that Oracle was able to "optimize" a join > strategy by completely eliminating access to a table. > > Heres the execution on Oracle 18c [2] and PostgreSQL 13 (beta) [3]. > > Is there a fundamental reason why PG can't do the same? > It does... did you see the “never executed” notice on the Postgres explain output? Regards, -- Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento