查询优化集中于cpu密集型(CPUbound)执行路径,而全缓存数据库将仍然集中于优化取页到大容量存储器的操作,而这已不再是问题。
Query optimization focuses on CPUbound execution paths, while a fully cached database will still be preoccupied with optimizing page fetches to mass storage that are no longer an issue.
Oracle服务器上CPU消耗的减少是因为新的作业能够更好地利用Oracle数据库中的优化来执行查询。
The reduction in CPU at the Oracle server was possible because the new job was able to make better use of optimizations within the Oracle database in order to resolve the query.
当查询准备好后,数据库将分析、编译和优化执行该查询的计划。
When the query is prepared, the database will analyze, compile and optimize it's plan for executing the query.
与Oracle和SQLServer等其他关系数据库管理系统一样,Informix也有内部优化器,负责选择最佳的查询执行计划。
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.
介绍RDBMS优化器的执行策略和分析了影响SQL查询效率的因素的基础上,提出了优化SQL查询效率的基本方法,以提高数据库查询的执行效率。
The basic optimization methods of the SQL query language is presented by comprehending executive tactics of RDBMS optimizer and analyzing the factors that affect the SQL query languages efficiency.
对于一个复杂的查询,寻找一个优化的执行策略是数据库系统开发成功的关键所在,此项研究目前在数据库领域仍属于N - P问题。
Searching an optimized executive strategy for every complex query is the key of success for database development. In database field, it is still an N-P problem.
数据库优化器为数据库查询提供一个最佳的执行策略。
The database optimizer provides an optimal executive strategy for database query.
数据库优化器为数据库查询提供一个最佳的执行策略。
The database optimizer provides an optimal executive strategy for database query.
应用推荐