"Carlo Stonebanks" <stonec.register@xxxxxxxxxxxx> writes: > Just to clarify: if I expect to join two tables that I expect to benfit from > indexed scans, I should create indexes on the joined columns on BOTH sides? Well, it all depends on the queries you plan to issue ... but for the particular query shown here, the lack of that index is the performance bottleneck. regards, tom lane
