Re: Inserting/deleting records into/out of table
Hi.
The query would wait for the load to finish.
Querys would have to wait for a delete statement to finish. A delete statement takes much longer than an ALTER TABLE table_name UNION=(...), unless you delete the whole table, which is implicitly transformed to TRUNCATE.
Regards
Ingo
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
11303
November 16, 2006 06:21AM
Re: Inserting/deleting records into/out of table
6823
November 20, 2006 08:54AM
6470
June 05, 2007 03:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.