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 |
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.