Optimizing Data Storage |
For the purposes of querying, cube loading, and creating data marts and data warehouses, all four data storage structures (explained in Overview of Common Data Sources) can be optimized to improve performance. Some optimization can be achieved, for example, by specifying transformation options in SAS Data Integration Studio. Some optimization requires hardware configuration, as in the case of SPD Engine tables. Cubes can be optimized for querying and loading during the cube loading process. For SAS tables, database tables, and SPD Engine tables, libraries can be defined in the metadata with options that enhance performance.
For more information, see these sections:
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.