Subject RE: [firebird-support] how to reduce the file size of the database after large amount of deletes ref/eDN8072730811
Author Alan McDonald
> I have check the indexes, there only these that the application wants.
> I will delete only the records and I will check the speed. I will
> inform you
> about my tests.
> Thank you guys for your time.
> Dennis

make sure that you have not created your own indexes on things like PKs and
FKs - FN makes it's own and there is a performance degradation if you
duplicate them