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]数据集的查询结果,所以整个时间段的销售数据执行的查询性能得到了改善。
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.
此场景的另一个副作用是数据库中的任何形式的实体化(预计算聚合)可能会被忽略,因为查询中不包含任何事实。
The database may contain materialized query tables (MQTs), the pre-joined and pre-aggregated tables for DWE OLAP models and cubes.
数据库可以包含物化查询表(MQT),即用于 DWEOLAP模型和多维数据集的预联结和预聚合的表。
I'd be able to "pre-load" this data into an actual table, and then query off that instead of using temp tables.
我可以将这些数据“预加载”到实际表中,然后查询而不是使用临时表。
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.
视图生成是执行单个查询的总开销的重要部分,因此实体框架让您可以预生成这些视图并在已编译项目中包含这些视图。
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.
本文还提出了三种具体算法来利用索引匹配结果进行进一步的查询。
In order to improve query performance, data warehouse usually contains pre-aggregation.
数据仓库通常都包含预聚集。
In order to improve query performance, data warehouse usually contains pre-aggregation.
数据仓库通常都包含预聚集。
应用推荐