I have unfortunately deleted a message to pgsql-general today which contained a query like: SELECT tab1.b, tab2.c FROM tab1, tab2 WHERE tab1.a=tab2.a; There was also a UNION following, but my memory fails me. My question is though, can an index be used for the above query? When I try it with an index on tab1.a and tab2.a, I get two hash joins and two seq scans. If there's any way to optimise this query, please let me know, Marc ************
