Stephan,
Thanks for your reply.
No I don't have indexes on the *_id fields in bus_pc_idc. Now that you
point it out it make perfect sense why this query would
take a while and give the impression it's hanging - it's all those seq
scans.
Thank you kindly, I really appreicate it.
Regards
Rudi.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
- [SQL] Referential integrity Freeze Rudi Starcevic
- Re: [SQL] Referential integrity Freeze Stephan Szabo
- Rudi Starcevic