The optimizer is dependent on accurate cardinality estimates to properly compute the cost of each query access plan considered.
优化器凭借精确的基数估计值来准确计算出每一个待定查询访问计划的成本。
Accurate index information and statistics are fundamental to cost-based decisions in the query optimizer.
准确的索引信息和统计信息是查询优化器中基于成本的决策的基础。
Whether it is application services being exposed or a simple generated data query service, the resulting data must be accurate and appropriate to the business context to be of any value.
无论公开的是应用程序服务,还是生成的简单数据查询服务,产生的数据对于业务上下文必须是准确和适当的,这样才能提供数据的价值。
The optimizer depends on accurate cardinality estimates to properly compute the cost of each query access plan considered.
优化器凭借精确的基数估计值来准确计算出每一个待定查询访问计划的成本。
Both statistical views and REOPT allow the optimizer to compute a more accurate cardinality estimate and consequently choose an optimal query execution plan.
统计视图和REOPT都使优化器可以计算出更精确的基数估计,而后选择一个最佳查询执行计划。
In order to obtain accurate results and provide the information pertinent to the business user the report manager has the ability to exercise fine control over the filters applied to each query.
为了获得准确的结果并提供与业务用户有关的信息,报表管理器能够对应用于每个查询的过滤器实施精细控制。
If the optimizer can peek into the query result (or partial query results), and armed with that foresight, then the information can be extremely useful to help determine a more accurate access plan.
如果优化器能预知查询结果(或部分查询结果),那么该信息对于帮助确定更精确的访问计划将非常有用。
The a case study using query annotation section of the article describes how you can determine if the estimate is accurate.
本文的使用查询注释的案例研究部分描述了如何确定估计是否准确。
To ensure that the optimizer selects the best query plan, it is important to keep internal statistics current and accurate.
为了确保优化器选择最佳的查询计划,使内部统计数据保持为最新并且最准确的十分重要。
You should also consider executing runstats on the MQT, so that the query optimizer has accurate information about the number of rows in the MQT and other statistics.
您还应该考虑在MQT 上执行runstats,以便查询优化器拥有关于 MQT 中的行数以及其他统计信息的准确信息。
Whether it is application services being exposed or a simple generated data query service, the resulting data must appropriate to the business context and be accurate to be of any value.
无论是公布应用程序服务还是生成的简单的数据查询服务,产生的数据都必须适合业务上下文,并且足够精确,如此才具有价值。
Given accurate statistics, the query optimizer generally comes up with correct selectivity estimates.
如果有了准确的统计信息,那么查询优化器一般能够得出正确的选择性估计。
It can provide an accurate and concise answer to a natural language query.
它能用准确、简洁的自然语言回答用户用自然语言提出的问题。
If we want to support accurate ranking, we would need to first execute the query against all shards and gather the relevant term frequencies, and then, based on it, execute the query.
如果我们想支持精确的排名,我们首先需要执行查询频率对所有碎片,收集相关的术语,然后,在此基础上,执行查询。
Administrators and students for the first time on the course fast and accurate information to query and modify.
管理员和学生可以在第一时间对选课信息进行快速精确的查询和修改。
Procurement information by category and geographical co-location, achieve accurate vertical query.
信息采购按分类和地域共同定位,实现精准的垂直查询。
Provide bus stations, bus lines query, bus transfer routes, public transportation map accurate information.
提供公交站点,公交线路查询,公交换乘线路,公交地图精准信息。
The manufacturing parameters of riveting process were adjusted and optimized. Read and query the accurate data automatically, and the report forms can be generated in detail.
实现了铆接过程加工参数的调整优化,理想加工参数的自动存取,详尽报表的输出等功能。
The manufacturing parameters of riveting process were adjusted and optimized. Read and query the accurate data automatically, and the report forms can be generated in detail.
实现了铆接过程加工参数的调整优化,理想加工参数的自动存取,详尽报表的输出等功能。
应用推荐