Chapter 10: Tuning for Performance and Efficiency
Understanding Performance Tuning
Sorting and Performance
User-Specified Sorting (SORTPGM= System Options)
Grouping and Performance
Indexes and Performance
Reviewing CONTENTS Output and System Messages
Optimizing WHERE Clause Processing with Indexes
Constructing Efficient Logic Conditions
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.