A customer had a challenge: split a series of events into groups. Starting with the earliest event, find the next event at least 7 days after this. Keep repeating this process until there are no more events.
They had built a recursive WITH query to run these calculations. The problem: it was too slow!
Join this session to see the process of analysing and improving the query and why recursive WITH was the wrong solution for this problem!
Share a link to this workshop via:
The QR code below is the URL for this workshop. Right-click to save the image to share with others.