“查询工作负载调优使我们更加主动,而不是被动的,”他说。
“Query workload tuning makes us proactive, not reactive,” he says.
通过对Oracle性能的主动和被动管理,以及优化工具SQLTrace、EXPLAINPLAN和优化器的使用,缩短了数据仓库用户查询响应的时间,提高了查询效率。
By using active and passive management for ORACLE and optimize tools like SQL TRACE EXPLAIN PLAN and ORACLE OPTIMIZER, the query response time is shortened and the efficiency is improved.
通过对Oracle性能的主动和被动管理,以及优化工具SQLTrace、EXPLAINPLAN和优化器的使用,缩短了数据仓库用户查询响应的时间,提高了查询效率。
By using active and passive management for ORACLE and optimize tools like SQL TRACE EXPLAIN PLAN and ORACLE OPTIMIZER, the query response time is shortened and the efficiency is improved.
应用推荐