CONTENTS
xiv
Changes to the SQL ............................................................................................................502
Bind Variable Peeking .........................................................................................................502
Identifying Plan Instability........................................................................................................505
Capturing Data on Currently-Running Queries .....................................................................505
Reviewing the History of a Statement’s Performance...........................................................506
Aggregating Statistics by Plan.............................................................................................508
Looking for Statistical Variance by Plan ...............................................................................509
Checking for Variations Around a Point in Time ...................................................................511
Plan Control: Solving the Problem............................................................................................513
Modifying Query Structure...................................................................................................513
Making Appropriate Use of Literals......................................................................................514
Giving the Optimizer some Hints..........................................................................................514
Plan Control: Without Access to the Code) ...............................................................................522
Option 1: Change the Statistics ...........................................................................................523
Option 2: Change Database Parameters ..............................................................................525
Option 3: Add or Remove Access Paths ...............................................................................525
Option 4: Apply Hint Based Plan-Control Mechanisms .........................................................526
Outlines ..............................................................................................................................526
SQL Profiles ........................................................................................................................538
SQL Plan Baselines .............................................................................................................555
Hint Based Plan Control Mechanisms Wrap Up ....................................................................562
Conclusion ..............................................................................................................................562
Index...................................................................................................................................565
剩余600页未读，继续阅读
qq_20074281
- 粉丝: 2
- 资源: 45
我的内容管理
展开
最新资源
- 批量文件重命名神器：HaoZipRename使用技巧
- 简洁注册登录界面设计与代码实现
- 掌握Python字符串处理与正则表达式技巧
- YOLOv5模块改进 - C3与RFAConv融合增强空间特征
- 基于EasyX的C语言打字小游戏开发教程
- 前端项目作业资源包：完整可复现的开发经验分享
- 三菱PLC与组态王实现加热炉温度智能控制
- 使用Go语言通过Consul实现Prometheus监控服务自动注册
- 深入解析Python进程与线程的并发机制
- 小波神经网络均衡算法：MATLAB仿真及信道模型对比
- PHP 8.3 中文版官方手册(CHM格式)
- SSM框架+Layuimini的酒店管理系统开发教程
- 基于SpringBoot和Vue的招聘平台完整设计与实现教程
- 移动商品推荐系统：APP设计与实现
- JAVA代码生成器：一站式后台系统快速搭建解决方案
- JSP驾校预约管理系统设计与SSM框架结合案例解析
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
