Thanks for taking the time to respond. I really appreciate it.
I will definitely try the bulk load and delete and see if that helps.
I cann't use cascade on delete because there are no relationships between tables. I should have specified that earlier.
I am trying to purge data from a group of tables but can only purge specific transactions based on a type. The type of transaction is only stored in one table and the rest only have the primary key in common.
Right now I am creating a jdbc program to group the transactions in an array to be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.