Em sáb, 11 de jul de 2020 às 14:20, <luis.roberto@xxxxxxxxxxxxxxx> 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
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
