Center workstation tests and controls field equipments, dynamically display technical process, field data and alarm, production information for statistical query.
中心工作站检测和控制现场设备,动态显示工艺流程和现场数据并报警,统计查询生产信息等。
Query drill down allows you to gather statistical information about each SQL statement executed on the system and analyze statement history.
可以通过查询钻取特性收集关于系统上执行的每个sql语句的统计信息并分析语句历史。
Using the same sample data just discussed above, the following illustrates the difference in cardinality estimates with and without the use of statistical view for the query.
下面使用以上讨论的相同的示例数据,阐释在使用和不使用查询的统计视图的情况下基数估计的差别。
Statistical profiles are then generated based on the data in the query feedback warehouse.
然后,基于查询反馈仓库中的数据生成统计配置文件。
These views include columns containing statistical information that is useful to the query optimizer.
这些视图包括一些包含对查询优化器有用的统计信息的列。
Both statistical views and REOPT allow the optimizer to compute a more accurate cardinality estimate and consequently choose an optimal query execution plan.
统计视图和REOPT都使优化器可以计算出更精确的基数估计,而后选择一个最佳查询执行计划。
So, the accuracy of getting an optimal plan is entirely dependant on the up-to-date statistical information about the database objects involved in the query.
因此,获得最佳计划的准确性完全取决于关于查询中所涉及的数据库对象的最新统计信息。
The optimizer would chalk out a query plan before performing the actual join operation itself by making use of the statistical data.
在执行实际的连接操作之前,优化器使用统计数据制定一个查询计划。
An exception to this is in V8 where fact table columns referenced in any query predicate must be included in the statistical view definition due to MQT routing limitations.
一个例外是在v8中,由于mqt路由限制,任何查询谓词引用的事实表列都必须包括在统计视图中。
Optimization guidelines and statistical views are useful features to compensate the access plan evaluations when exceptions in query performance occur.
当查询性能中出现例外情况时,优化指南和统计视图特性对于弥补访问计划估计的不准确性非常有用。
For statistical view, the ENABLE query optimization clause will cause the view, and its associated statistics to be used to improve the query optimization.
对于统计视图,ENABLEQUERYoptimization子句将导致该视图以及与之相关联的统计信息被用于改进查询优化。
They should be considered carefully, as there is an associated cost of query matching for guidelines, or compilation for statistical views.
但是使用这两个特性时要谨慎,因为对于优化指南,需要额外的查询匹配开销,而对于统计视图,又有编译方面的开销。
Hence, the need for statistical views arises in query plan optimization.
因此,在进行查询计划优化时,就需要使用统计视图。
The query optimizer USES the SYSSTAT catalog views in the database to retrieve the statistical information of the database objects and determine the best way to access the data.
查询优化器使用数据库中的SYSSTAT目录视图来检索数据库对象的统计信息,并确定访问数据库的最佳方法。
This information might include per-user profile data, or per-query statistical information.
信息可能包括对每个用户的描述数据,又或者对每次请求的统计信息。
The statistical view is kind of like the Materialized Query Table (MQT), except that there is no need for materialization.
统计视图有点类似于物化查询表(MaterializedQueryTable,MQT),不同的是统计视图不需要物化。
The system possessed six modules: query system, system management, experimental approach, statistical analysis, picture management and help.
本系统包括系统查询、系统管理、试验方法、统计分析、图片管理及使用帮助等六个模块。
This paper introduces the basic query format and the applications of SELECT-SQL statement in the query, programming and statistical analysis of library's management.
介绍了查询语句的基本格式以及SELECT—SQL语句在图书馆管理的查询、编程、统计分析中的应用。
BI applications include the activities of decision support systems, query and reporting, online analytical processing (OLAP), statistical analysis, forecasting, and data mining.
商务智能的应用包括支持性决策系统,提问及报告,在线分析程序,统计分析,预测及数据探测。
Information query module, statistical analysis module, price forecast module, volume-price decision module and system management module are included in design of functions.
功能的设计主要包括信息查询、统计分析、价格预测、量价决策和系统管理模块。
Enquiries can be different according to query show different results, according to statistical requirements and also show different results.
查询可根据查询条件的不同显示不同的查询结果,同时也可根据统计要求显示不同的结果。
And the results of the query and statistical budget.
并根据查询和统计的结果预算。
RESULTS a movement disorders database having storage, data input and output, search query, statistical analysis function etc. was established.
结果建成一个具有存储、数据输入输出、检索查询、统计分析等功能的运动障碍疾病数据库。
On the basis of analyzing of process of producing query, this paper puts forward a new method of query expansion on the basis of model of statistical machine translation.
该文在分析了查询产生模型的基础上,提出了一种新的基于统计机器翻译的查询扩展方法。
System include: Integrated Query, Teaching management, Allowance management, Allowance Statements, Statistical Analysis and password management functions of six parts.
系统主要包括:综合查询、教学管理、津贴管理、津贴报表、统计分析和密码管理六个部分的功能。
System include: Integrated Query, Teaching management, Allowance management, Allowance Statements, Statistical Analysis and password management functions of six parts.
系统主要包括:综合查询、教学管理、津贴管理、津贴报表、统计分析和密码管理六个部分的功能。
应用推荐