On Fri, 2003-06-20 at 15:53, Yusuf wrote: > Why would the following query take soo long to run? What does 28.12 msec represent, > since the total running time is > 16801.86 ms.
I'd hazard to guess that you have a whole slew of foreign keys cascading to delete, update, or check many rows from other tables. Those are not represented in the explains at the moment. -- Rod Taylor <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
Description: This is a digitally signed message part