Tài liệu Cost-Based Oracle Fundamentals

Foreword . xiii
About the Author . xv
About the Technical Reviewers xvii
Acknowledgments . xix
Introduction . xxi
■CHAPTER 1 What Do You Mean by Cost? 1
■CHAPTER 2 Tablescans 9
■CHAPTER 3 Single Table Selectivity 41
■CHAPTER 4 Simple B-tree Access 61
■CHAPTER 5 The Clustering Factor 87
■CHAPTER 6 Selectivity Issues . 115
■CHAPTER 7 Histograms 151
■CHAPTER 8 Bitmap Indexes . 181
■CHAPTER 9 Query Transformation . 207
■CHAPTER 10 Join Cardinality 265
■CHAPTER 11 Nested Loops 307
■CHAPTER 12 Hash Joins . 319
■CHAPTER 13 Sorting and Merge Joins 353
■CHAPTER 14 The 10053 Trace File . 403
■APPENDIX A Upgrade Headaches 453
■APPENDIX B Optimizer Parameters 465
■INDEX 475