O'Reilly logo

PROC SQL: Beyond the Basics Using SAS, Second Edition by Kirk Paul Lafler

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required