> 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))?
Yup - all columns in the statement are indexed, and they are all
numeric(10,0).
> Also, have you run VACUUM ANALYZE lately?
Yup - just before the last run.
Will get together my tuning data now.
David
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
