Hello Experts!
I have a performance problem when deleting data from a large table.
The table has about 3.000.000 rows, if I try to delete about 1.300.000 entries it would take hours(more then 24H), which is too long for the productive system.
The table has 4 fields with foreign key relationships to other tables and 4 tables have foreign key relationships to the table.
The entries to be deleted have no foreign key relationship to the dependent tables, so they should be easy to delete.
When selecting the data to be deleted, a result is displayed within one second.
What can I do to make the deletion run faster?
We have maxdb 7.9.10.08.
Thanks and BR
Hermann