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
(select accountmaster.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