Those changes cut the costs for the original query down to half and also greatly reduced the query response time.
那些更改将原始查询的成本缩减了一半,同时也极大地减少了查询响应时间。
One option for authors and analysts to improve interactive query response time is to filter their reports or analyses first.
对设计人员和分析人员来说,提升交互查询时间的方法之一就是先过滤报表或分析。
However, when dealing with very large data sets, you can further improve the query response times of a native XML database by following a few general common sense guidelines.
但是,在处理超大型数据集时,您还可以通过遵循以下一般原则进一步改善原生xml数据库的查询响应时间。
Figure 7 shows the query response times as a function of the number of documents in the table, ranging from 1,000 to 100,000 documents (when no indexes or side tables are used).
图7显示查询响应时间作为表中文档数(范围从1,000到100,000)的函数(不使用索引或索引表)。
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.
通过对Oracle性能的主动和被动管理,以及优化工具SQLTrace、EXPLAINPLAN和优化器的使用,缩短了数据仓库用户查询响应的时间,提高了查询效率。
应用推荐