'access' is one of those weasel words like 'process' or 'change'. 🙂 I've found that small, targeted explicit pulls (like picking all IDs from a main table) is fast (using indeces when possible) and then I use that pull to do cross-platform joins back to the database from other tables (like detail lines for claims, for example). Especially efficient in a parallel processing environment. Focus on limiting transfers from the database to SAS as much as possible, doing the bulk of selections, calculations, aggregations and so on back on the database machine itself. Let database engines do what they do best.
... View more
