Chapter 10: Tuning for Performance and Efficiency


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




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, ...

Get PROC SQL: Beyond the Basics Using SAS, Second Edition, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.