Optimizing Your SQL Usage

Overview: Optimizing Your SQL Usage
Passing Functions to the DBMS Using PROC SQL
Passing Joins to the DBMS
Passing the DELETE Statement to Empty a Table
When Passing Joins to the DBMS Will Fail
Passing DISTINCT and UNION Processing to the DBMS
Optimizing the Passing of WHERE Clauses to the DBMS
Using the DBINDEX=, DBKEY=, and MULTI_DATASRC_OPT= Options
Copyright © SAS Institute Inc. All rights reserved.