hi sean, sorry i am novice to DB so couldn't really understand what data movement means. You are correct the stats are stale. but i have a test environment, i update the stats for these tables in the test and ran the query but it took exactly the same time 50 mins to run.

did you mean how much data is added to each table per day? if so then the there are about a million records added to the sales_fact everyday