Now that's an interesting thought. I haven't done much with views on the SAS side, only in Netezza, so I'll check into this. However, the example I posted was just to show how libraries can work using the DBMSTEMP=YES option in the LIBNAME statement. As a typical use case, users will query a very large Netezza table, bringing the results into WORK. Once they finish tweaking the query, they join the SAS data set to another large Netezza table - a heterogeneous join, which creates performance problems. They'll often do this through multiple QB tasks until they get the results they want. Much of this is about training and monitoring. We need to make our users understand how to use the system well, and I've set up a daily report from Netezza that lists the longest running queries from SAS users. Soon I'll have the same for the creators of large SAS data sets.
... View more