Simple DELETE takes over 12 minutes

[mahmed1]

Hi All

I am trying to delete all data from a table which is taking over 12 minutes each time (i do have over 500k records) to delete

DELETE * FROM tblRollingData thats my query but it takes forever to run (Can you please help me speed this up)

i also have another DELETE in another table but this takes long but not as long

DELETE * from tbl_tempData WHERE Date_ is not NULL

Please Please help me speed this UP

thank You

 

[mahmed1]

Hiya

ill give that a go

I inherited these DBs sol will have to check

all i know is that in code there is an import that gets put into the temp table
I do a cleanse and then put all data into a rolling table so i dont think there is any link with these 2 tables