I am deleting 80 millions of records from a table , for this tpt is taking 12 hours to complete where as bteq deleting data in just 2 hours. Actually tpt should be more faster than the bteq. Please suggest me how can i avoid this long run thrugh tpt.
Are you using the Delete Task to delete the records?
Or the generic DELETE FROM . . . ?
Hi Steve, pelase let me know what exactly is delete task.My TPT script includes apply which deletes data, exported by export operator. Is this delete is different to your delte task
Please send me the script you are using currently to delete those 80 million rows.
The only privacy issues probably involve any password and you can always just remove that text.
I need to see all of the other attributes you have set up in the script.
What is this script attempting to do?
You are using the Export operator to read data from a file, in order to provde values for the WHERE clause in the DELETE?
The "Delete Tak" option in the Update operator is probably more what you are looking for. Please look at the "Delete Task Option" in the TPT Reference Manual (Chapter 16) for information.
I am not using using the parameter Deletetask='Y' as I am also inserting few records in to table with the same script. But number of records that are being inserted are minimal compared to the delete records. Pls look below script parameters I am using.
I do not see where you specify that rows are being inserted.
The only DML statements I see is a DELETE.