By Christian Antognini
PART 1 Foundations
CONTENTS
CHAPTER 1 Performance Problems.. . . . . . . . 3
CHAPTER 2 Key Concepts ..13
PART 2 Identification
CHAPTER 3 Identifying Performance Problems. . . . . . . . . . . . . 35
PART 3 Query Optimizer
CHAPTER 4 System and Object Statistics.. 109
CHAPTER 5 Configuring the Query Optimizer. . . . . . . . . . . . . . 169
CHAPTER 6 Execution Plans.. . . . . . . . . . . . . 195
CHAPTER 7 SQL Tuning Techniques.. . . . . . 247
PART 4 Optimization
CHAPTER 8 Parsing... . . . . 309
CHAPTER 9 Optimizing Data Access.. . . . . . 339
CHAPTER 10 Optimizing Joins.. . . . . . . . . . . . 409
CHAPTER 11 Beyond Data Access and Join Optimization. . . . 459
CHAPTER 12 Optimizing the Physical Design. . . . . . . . . . . . . . . 527
PART 5 Appendixes
APPENDIX A Downloadable Files.. . . . . . . . . . 551
APPENDIX B Bibliography..563
INDEX.... . . . . 567
CODEhttp://2341887079644.usercash.com