Chapter 12: Tuning for Performance and Efficiency
Understanding Performance Tuning
User-Specified Sorting (SORTPGM= System Options)
Reviewing CONTENTS Output and System Messages
Optimizing WHERE Clause Processing with Indexes
Constructing Efficient Logic Conditions
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 ...
Get PROC SQL, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.