I have written 3 queries to extract and store data from the Click, Open and Bounce views and I have set them to update so only the delta should be added.
When I set the update type to overwrite they work, but when I set them to update only they keep failing with a timeout message.
Can anyone tell me why the update would be timing out when the overwrite works perfectly and is dealing with much bigger amounts of data?
Query text below for the click query, but the others are all similar.
Primary keys on the DE are Event Date, URL, Subscriber ID and Job id as I only want one click on each link on each day for each job.
SELECT c.AccountID ,c.JobID ,c.SubscriberID ,c.SubscriberKey ,c.EventDate ,c.URL ,j.EmailID ,j.EmailName From _Click c INNER JOIN _Job as J on j.jobID = c.jobID Where IsUnique ='True'