Slow Deletes

[Randy Chrismon]

I just ran the following on a table with ln_cash having about 190,000 
records and cash_exceptions having about 6,000:

mysql> delete ln_cash from ln_cash,cash_exceptions where 
ln_cash.docunid=cash_exceptions.docunid;
Query OK, 6103 rows affected (3 min 10.21 sec)

Both tables have unique indexes on docunid. This seems unreasonably long 
to me. Any notion what I'm missing here? I will say that the prior 
command was to alter the cash_exceptions table to create the unique 
index on docunid. That operation took about half a second which makes me 
wonder if the index was actually created -- although show index says it 
was.

Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]