Being able to write something like:
WITH xxx AS MATERIALIZED ANALYZED INDEXED ON field1 ( SELECT DISTINCT myfield AS field1 FROM table1 ) SELECT field2 FROM table2 JOIN xxx USING(field1);would help a lot in some cases. Of course, the syntax is just a thought but the general idea is there.