I was joining 2 tables, 5 GB and 1GB in size respectively (5g left join 1g). (Both had around 1 million rows) Took around 13 minutes, which moderate compared to queries I generally run. During the join a file called "sastmp-000000111.sas7butl" was created which was 127 GB in size. My access was blocked and now I have to raise a ticket to get it unlocked, with an optimised query to perform the same task. But I have no clear idea on what would be an optimal query. I've heard about indexes, but not sure if they would be useful, or how to use them here.
... View more
