PROC SQL: Beyond the Basics Using SAS, Second Edition

Chapter 10: Tuning for Performance and Efficiency

Introduction

Understanding Performance Tuning

Sorting and Performance

User-Specified Sorting (SORTPGM= System Options)

Automatic Sorting

Grouping and Performance

Splitting Tables

Indexes and Performance

Reviewing CONTENTS Output and System Messages

Optimizing WHERE Clause Processing with Indexes

Constructing Efficient Logic Conditions

Avoiding UNIONs

Summary

 

Introduction

A book on PROC SQL would not be complete without some discussion of query optimization and performance. Enabling a query to run efficiently involves writing code that can take advantage of the PROC SQL query optimizer. Because PROC SQL is designed to handle a variety of processes while accommodating small to large database environments, ...