Chapter 10. Tuning for Performance and Efficiency
| 10.1 | Introduction 326 |
| 10.2 | Understanding Performance Tuning 326 |
| 10.3 | Sorting and Performance 327 |
| 10.3.1 User-Specified Sorting 328 | |
| 10.3.2 Automatic Sorting 328 | |
| 10.4 | Splitting Tables 328 |
| 10.5 | Indexes and Performance 329 |
| 10.6 | Reviewing CONTENTS Output and System Messages 330 |
| 10.7 | Optimizing WHERE Clause Processing with Indexes 335 |
| 10.7.1 Constructing Efficient Logic Conditions 335 | |
| 10.7.2 Avoiding UNIONs 337 | |
| 10.8 | Summary 339 |
Get PROC SQL: Beyond the Basics Using SAS® 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.
