Hi all,



Which is the best way to perform a massive deletion on a table with
million of rows ?



In other environments we first perfom a select to gather the dbkeys of
the records to be deleted and then delete them performing commits every
n records. Is there something similar in Firebird ?

Jordi.





Jordi Puigsegur Figueras

jordi.puigsegur@...
<mailto:jordi.puigsegur@...> (+34) 971 788 206 ext. 1852
(+34) 971 788 208 fax
www.infomallorca.es <http://www.infomallorca.es/>







[Non-text portions of this message have been removed]