You can do one more test. Remove the group by and see how many rows are returned after the 2 tables join. That will give you good idea how much space is needed


select shows 5075 rows wihtout group by. It took 30 minutes to run the select statement.