查询优化集中于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.
应用推荐