Hannu Krosing wrote:
> try using
> create index registrationtype_index on accounts (registrationtype);
OK did that, and am rerunning the query.
The explain now shows explain select accountdetail.domain from accountdetail where accountdetail.domain not in
(selectaccountmaster.domain from accountmaster); NOTICE: QUERY PLAN:
Seq Scan on accounts (cost=3667.89 rows=34958 width=12) SubPlan -> Index Scan using registrationtype_idx on
accounts (cost=2444.62
rows=33373 width=12)
EXPLAIN
Will let you all know when it completes.
--------
Regards
Theo