[SQL] Need another way to do this, my sql much to slow...

_num_idx on record_of_claims (cost=0.00..152.99 rows=2635 width=8) (actual time=0.55..2240.15 rows=80466 loops=1) Total runtime: 7931.63 msec Is there a better, read "Faster", way to achieve this? Jerry Wintrode Very Newbie Postgres User ---

Re: [SQL] Need another way to do this, my sql much to slow...

over again. In this was I can cut my processing time to 6/10th of a second. But I have to create/drop/rename tables on a time interval. Not the best solution. Jerry Wintrode Network Administrator Tripos, Inc. ---(end of broadcast)--- TIP 8: expla

Re: [SQL] Need another way to do this, my sql much to slow...

m_count FROM record_of_claims WHERE (record_of_claims.env_sender_num = (SELECT env_from_senders.env_sender_num FROM env_from_senders WHERE (env_from_senders.envelope_from = intext::character varying))) GROUP BY record_of_claims.env_sender_num ); RETURN result; END; ' LANGUAGE 'plpgsql';