Chapter 12: Tuning for Performance and Efficiency

Introduction. 391

Understanding Performance Tuning. 391

Sorting and Performance. 392

User-Specified Sorting (SORTPGM= System Options) 392

Automatic Sorting. 393

Grouping and Performance. 393

Splitting Tables. 393

Indexes and Performance. 394

Reviewing CONTENTS Output and System Messages. 395

Optimizing WHERE Clause Processing with Indexes. 398

Constructing Efficient Logic Conditions. 398

Avoiding UNIONs. 401

Summary. 404

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.