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 |