我应该多久运行具有注册表优化扫描?
针对带有岛屿的轮廓截面,提出并实现分区直线扫描算法以优化扫描路径。
In view of the profile with islands, the divisional linear scanning algorithm was put forward and implemented to optimize the scanning paths.
目的:规范颈动脉粥样硬化斑块高分辨磁共振成像方法,优化扫描序列及参数。
Purpose: To develop optimal scan sequences and parameters of high resolution MRI for atherosclerotic carotid plaque.
以新息序列的平均平方和为评价函数优化扫描光谱的峰位,消除扫描过程中可能产生的波长定位误差,从而保证滤波结果的准确性,并使实际检出限显著改善。
The whiteness of the innovation sequence for an optimal filter was explored to be the criterion for the correction of the wavelength positioning errors which may occur in spectral scans.
它也允许我们在部署期间执行广泛的优化,即潜在地扫描字节码和优化代码路径,而不会影响在线系统。
It also allows us to perform extensive optimizations during deployment, potentially scanning byte code and optimizing code paths, without impacting online systems.
例如,使用不正确的谓词会妨碍优化器使用索引扫描,即使在索引可用的情况下。
For example, improperly coded predicates might prevent the optimizer from using an index scan even when the index is available.
因此,在决定选择哪种联接方法时,优化器为内部表扫描平衡排序成本和性能优势以便促进决策。
Therefore, when deciding which join method to choose, the optimizer balances the sort cost and the performance benefit for the inner table scan to drive the decision.
DB 2优化器能够感知分区,在执行查询时只扫描相关的数据分区。
The DB2 Optimizer is data-partition aware, and only relevant data partitions are scanned during query execution.
如果将其值设置为0,那么当存在合适的索引时,优化器就选择索引扫描而非表扫描,甚至不考虑估算成本。
If the value is set to 0, then the optimizer chooses index scans over table scans if appropriate indexes exist, without even considering the estimated costs.
访问计划指示,强制优化器使用指定的访问方法进行数据检索,要么是连续扫描,要么是索引扫描。
Access plan directives that force the optimizer to use the designated access method for data retrieval, either sequential scan or index scan.
如果没有创建合适的索引,或者如果索引扫描的成本更高一些,优化器通常就选择表扫描。
The optimizer normally chooses a table scan if no appropriate index has been created or if an index scan would be more costly.
对这个参数进行优化,可以降低扫描开销。
准妈妈们应该得到专家团队的帮助和并且至少有过6次扫描,英国国家临床优化研究所表示。
Mothers-to-be should be referred to specialist teams and receive a minimum of six scans, says NICE.
它还针对完全表扫描(一个最常见—也最耗时—的商业智能查询访问模式)进行了优化。
It's also optimized for full table scans (one of the most common-and most time-consuming-business intelligence query access patterns).
默认情况下,优化器考虑这种类型的扫描。
如果没有索引满足所取的行的要求顺序,或者优化器断定排序的代价低于索引扫描,那么就需要进行排序。
Sorting is required when no index satisfies the requested ordering of fetched rows, or the optimizer determines that a sort is less expensive than an index scan.
通常情况下,在基础索引提供好处(如唯一索引访问、避免排序或一些类似的好处)时,可通过优化器选择非匹配索引扫描。
Typically, a non-matching index scan is chosen by the optimizer when the underlying index provides benefits such as index-only access, avoids sort, or some similar benefit.
通常情况下,在外部输入的基数显然不小且对于内部表没有一种有效的访问方法时,优化器会选择合并扫描联接。
Typically, the optimizer chooses merge scan join when the cardinality of the outer input is not obviously small and there is no efficient access method for the inner table.
查询优化器的一项新特性支持一种新的索引扫描,即索引自连接路径。
A new feature of the query optimizer supports a new type of index scan, called an index self-join path.
在缺少当前统计的情况下,优化器选择对参与联接的两个表进行表扫描。
The optimizer, in the absence of current statistics, is choosing to do a table scan on both tables involved in the join.
账单表出了什么问题,使得优化程序认为需要顺序扫描整个表?
What is wrong with the bills table that the optimizer thinks it should sequentially scan the entire table?
优化器中的多索引扫描是OLTP的另一大赢点。
Multiple index scans in the optimizer are another big win for OLTP.
如图8的IXSCAN描述符所示,通过优化器利用的索引的领先列是PRODUCT _ NUMBER,其不为合并扫描联接提供所需的顺序。
As shown in the IXSCAN descriptor in Figure 8, the leading column of the index exploited by optimizer is PRODUCT_NUMBER, which does not provide the order required for merge scan join.
这个值越低,优化器就越有可能选择扫描网格索引。
The lower this value is the more likely the optimizer will choose to scan the grid index.
一个SQL优化器会选择扫描一个索引,而不是一个表,因为索引通常比表小,但是这只是一个微小的改进。
An SQL optimizer may choose to scan an index rather than a table because indexes are usually smaller than tables, but this is a marginal improvement.
通过分析多边形轮廓的填充特点,提出了一种填充扫描矢量方向的优化方法。
Through analyzing the filling characteristics of polygonal contours, an optimization method of scanning vectors for filling sectional contours was presented.
因此,实现PAT系统伺服控制器小型化和对扫描算法的优化具有重要的意义。
Thus, it is very valuable to miniaturize the PAT system servo controller and optimize the scanning algorithm.
建立了机载激光水下目标探测中的卵形螺旋线扫描系统的数学模型,提出了点阵均匀性优化方案。
A mathematical model for an ovoid spiral scanning system with airborne laser for underwater object detection is developed and a scheme for dot matrix uniformity optimization is proposed.
优化的拼接算法是环形子孔径扫描测量大口径非球面光学元件的关键问题。
Optimal stitching algorithm is extremely important for testing large-aperture aspherical optical elements by annular sub-aperture scanning technique.
注释:所谓的优化就是WHERE子句利用了索引,不可优化即发生了表扫描或额外开销。
Annotate: So called optimizing is WHERE clause used index, cannot optimize happened to express scanning or additional expense namely.
应用推荐