Update from Select in Greenplum
I want do fast update in my GP table, and i created index in source table, to improve perfomance but it work very slow, i test same code in Postgres and see that it work very fast and use index when performing subquery, why GP not use index in subquery to improve perfomance??? i also tested with SET enable_indexonlyscan = on;
result was same