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和优化器的使用，缩短了数据仓库用户查询响应的时间，提高了查询效率。
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也有内部优化器，负责选择最佳的查询执行计划。
应用推荐