Yes, the query operates only on indexed columns (all numeric(10)'s).
Column | Type | Modifiers -------------------------------+-----------------------------+-------------- --------------- user_account_id | numeric(10,0) | not null [snip] Indexes: user_account_pkey primary key btree (user_account_id), Foreign Key constraints: $1 FOREIGN KEY (lang_id) REFERENCES lang(lang_id) ON UPDATE NO ACTION ON DELETE NO ACTION, $2 FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE NO ACTION ON DELETE NO ACTION, $3 FOREIGN KEY (user_role_id) REFERENCES user_role(user_role_id) ON UPDATE NO ACTION ON DELETE NO ACTION
And what about commercial_entity.user_account_id. Is it indexed and what is its data type (i.e. does it match numeric(10,0))?
Also, have you run VACUUM ANALYZE lately?
Joe
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
