To view the query access plan using the optimization profile created, the SET CURRENT optimization profile statement can be used in combination with the SET CURRENT EXPLAIN MODE statement, as follows.
要查看使用了创建的优化配置文件的查询访问计划,可以结合使用SET CURRENT OPTIMIZATION profile语句和SET CURRENT EXPLAIN MODE statement,如下所示。
For statistical view, the ENABLE query optimization clause will cause the view, and its associated statistics to be used to improve the query optimization.
对于统计视图,ENABLE QUERY optimization子句将导致该视图以及与之相关联的统计信息被用于改进查询优化。
Methods Analyze the importance of the queuing system for attendance at out-patient treatment process optimization from the patients, doctors and managers view.
方法从患者、医生和管理者的角度分析了分诊排队系统对于优化门诊就医流程的重要性。
应用推荐