The fact "more than a billions of records" should trigger you to rethink your use case.
Try to use the data where it resides, and only extract subsets/aggregates.
This can be achieved using SQL pass through (explicit and/or implicit).
Or if the dataset is a SAS dataset, use SAS/CONNECT or other methods to use it directly.
... View more
