As stated above, performance is the major concern in query tuning.
如上所述,性能是查询调优中主要关心的问题。
Those familiar with System I and database query performance analysis and tuning, understand that controlling the optimization goal is a critical step to optimizing performance.
那些熟悉systemi和数据库查询性能分析和调优的人就会理解控制优化目标是优化性能的关键步骤。
This section focuses on tuning query performance for federated systems. Before tuning query performance
本节主要关注联邦系统中查询性能的调优。
Optim query Tuner provides a series of advisors to automate the query tuning by giving recommendations, which you can review and implement directly from the product to resolve a performance issue.
OptimQueryTuner提供了一系列建议工具,通过提供建议来自动化查询调优,从而您可以直接在本产品中评审和执行,从而解决性能问题。
Launch into Optim Query Tuner (if installed) directly from SQL-related dashboards to do immediate tuning of problematic SQL, closing the loop on performance problem resolution.
直接从SQL相关的面板启动OptimQueryTuner(如果已安装)来快速调整有问题的SQL,结束性能问题解决循环。
The following is one of many approaches to tuning federated query performance.
下面是用于调优联邦查询性能的众多方法中的一种。
It helps eliminate the costs of traditional performance tuning, such as indices, materialized query tables (MQTs), and query plan tuning that required extensive time and expensive resources.
它有助于消除传统性能调优的成本,比如索引、物化查询表(Materialized Query Table,MQT)、以及需要大量时间和昂贵资源的查询计划调优。
Database System Design, Implementation, and Administration, Query Optimization, and SQL Performance Tuning.
数据库系统设计,实施,管理,查询优化和SQL性能调优。
Database System Design, Implementation, and Administration, Query Optimization, and SQL Performance Tuning.
数据库系统设计,实施,管理,查询优化和SQL性能调优。
应用推荐