Search results
-
O
table count does not change after importing records
Hello all, I need to export some old records and delete them, but want to import them later when a user wants to access those records. so I am testing my scripts and run into an issue that I can not understand. The SQL query or ABL query returns the total records, let's say 1000. I export 100...- ohchaos
- Thread
- Replies: 17
- Forum: Database Admin
-
O
Fast and safe way to delete large number of records
Hello, I need to delete lots of records which is half of the big table (over 60 million records) joining the other table in other database. I can write the delete statement, but wan to run it fast and more importantly do commit after deleting1000 records to avoid the blocking. How can I do...