Another side effect to this scenario is that any form of materialization (pre-calculated aggregates) in the database may be ignored since no fact is included in the query.
此场景的另一个副作用是数据库中的任何形式的实体化(预计算聚合)可能会被忽略,因为查询中不包含任何事实。
Because query results from the [HistoricSales] cube are pre-cached, the performance for queries that are run against the sales data of the entire time period is improved.
因为预先缓存了来自[HistoricSales]数据集的查询结果,所以整个时间段的销售数据执行的查询性能得到了改善。
The database may contain materialized query tables (MQTs), the pre-joined and pre-aggregated tables for DWE OLAP models and cubes.
数据库可以包含物化查询表(MQT),即用于 DWEOLAP模型和多维数据集的预联结和预聚合的表。
Query results are returned pre-processed by the pureQuery runtime into a wide choice of objects, such as Iterators of populated pureQuery beans, or Lists of column name to column value Maps
返回查询结果,由pureQuery预处理为多种对象,例如已填充的 pureQuerybean的Iterators,或者列名的Lists,或者列值Maps。
An MQT can be used to enhance query performance through the pre-computation of aggregate values. For example.
MQT可用于通过预先计算聚合值来增强查询性能。
According to the processing procedure of query pre-compiler, this paper givens the general design and implementation of syntax analysis, semantics analysis in MDBI query pre-compiler.
按照查询预处理的处理过程,分别描述了MDBI查询预处理器中词法分析、语法分析、语义分析的设计和实现。
This text goes deep into discussing the query of ROLAP in optimization based on pre-count summary and the query of sample based on query optimization.
而查询优化是解决ROLAP性能问题的重要环节之一,本文针对基于预计算汇总的ROLAP查询优化及基于采样的查询优化进行深入的探讨。
Also three algorithms are presented to query XML documents using pre-match result.
本文还提出了三种具体算法来利用索引匹配结果进行进一步的查询。
Because view generation is a significant part of the overall cost of executing a single query, the Entity Framework enables you to pre-generate these views and include them in the compiled project.
视图生成是执行单个查询的总开销的重要部分,因此实体框架让您可以预生成这些视图并在已编译项目中包含这些视图。
I'd be able to "pre-load" this data into an actual table, and then query off that instead of using temp tables.
我可以将这些数据“预加载”到实际表中,然后查询而不是使用临时表。
In order to improve query performance, data warehouse usually contains pre-aggregation.
数据仓库通常都包含预聚集。
In order to improve query performance, data warehouse usually contains pre-aggregation.
数据仓库通常都包含预聚集。
应用推荐