SQL性能顾问(SPA,SQL Performance Advisor)和自动化的SQL计划管理(SPM,SQL Plan Management)工具,通过建立单独SQL语句调整前的最佳基线,使得数据库管理员的生活变得轻松。
基于1个网页-相关网页
Enhancing SQL Plan Management 增强SQL执行计划管理
Like other relational database management systems such as Oracle and SQL Server, Informix has its internal optimizer, which is responsible for selecting the best query execution plan.
与Oracle和SQL Server等其他关系数据库管理系统一样,Informix也有内部优化器,负责选择最佳的查询执行计划。
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性能的主动和被动管理,以及优化工具SQL Trace、EXPLAIN PLAN和优化器的使用,缩短了数据仓库用户查询响应的时间,提高了查询效率。
应用推荐