Managing Large Data With SAS SPD Server

Overview

This paper provides the concepts behind demonstrations of how one can enhance query performance when one uses the SAS SPD Server to manage large data tables. This paper does not cover the main concepts for Dynamic Clusters or Parallel Join. This paper focuses on managing data within standard SAS Scalable Performance Data Server (SPD Server) tables, and therefore Dynamic Cluster tables, to enhance data querying. There are three common types of queries for which data within a table can be optimized: ordered processing, subsetting, and a hybrid of ordered processing and subsetting.