You need a rolling 7-day sum of page_views per user. The query below runs slowly: SELECT user_id , event_date , SUM ( page_views ) OVER ( PARTITION BY user_id ORDER BY event_date RANGE BETWEEN INTERVAL 6 DAYS PRECEDING AND CURRENT ROW ) AS rolling_views FROM web_events ; What change gives the biggest performance boost on Photon-enabled Databricks SQL?