When
you select a SAS LASR Analytic Server table as an
input table for a
data query, be aware of the following
best practices if the table is large. If the table is not large, then using it for input requires
no special considerations.
Here
are the considerations for using a large SAS LASR Analytic Server
table as an input table:
-
A WHERE clause is processed in
memory by the server if no aggregations or joins are used. Specify
a filter on the Where tab so that you use
only the rows that you want.
-
Instead of using a data query (which transfers the data from the server to the SAS
Workspace Server and then performs
the join), you can create a LASR
star schema. The LASR star schema performs the join in memory with other in-memory tables.