But what if our non-index predicates look like this.
但如果我们的非索引谓词如下所示,情况有会怎样呢?
What if we added the following non-index predicates to our SQL!
如果我们将以下非索引谓词添加到我们的SQL将会怎样呢?
Second, regardless of the order in which they are coded, Stage 1 non-index predicates are applied in the following order.
第二,无论谓词的编码顺序如何,Stage1非索引谓词都按以下顺序应用?
What I'm saying here is that for non-index predicates, DB2 does not consider the COLCARD or the COLUMN DISTRIBUTION statistics.
我想说的是,对于非索引谓词,DB 2不会考虑COLCARD或COLUMN DISTRIBUTION统计数据。
With host variables or literals, DB2 does not consider this factor for non-index predicates; only you can take this fact into account and code accordingly.
使用主变量或实际文本时,DB 2不会对非索引考虑这个因素;只有您能够考虑这个因素并相应编码。
Better control over manual indexing and index writing (RAM consumption, non-compound file format flag etc).
更好的控制手工索引和索引编写(RAM使用、非混合的文件格式标志等等)。
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.
通常情况下,在基础索引提供好处(如唯一索引访问、避免排序或一些类似的好处)时,可通过优化器选择非匹配索引扫描。
The option can be used in non matching index scans in a screening fashion and as part of index-only access.
该选项以筛选的方式用于非匹配索引扫描,且是仅索引访问的一部分。
The table is logically joined to itself, and the more selective non-leading index keys are applied as index bound filters to each unique combination of the leading key values.
首先在逻辑上将表与其自身连接,然后将更具有选择性的非起始索引键作为索引绑定过滤器,应用于起始键值的每个惟一的组合。
An index scan can be non-matching, which means that there are no restrictions in the scan of the underlying index.
索引扫描可以是非匹配的,这意味着在基础索引的扫描上没有限制。
Correlated subqueries will greatly degrade the speed of data retrieval, especially for non-selective queries on huge tables with millions of rows and with no index.
相关子查询将极大地降低数据检索的速度,对于拥有几百万个行但没有索引的大型表的非选择性查询更是如此。
First, define the non-Web-accessible directory that will contain the search index. This is where the indexed items will be stored.
首先,定义这个不能通过网络访问的目录,此目录将包含搜索索引,即索引过的条目将会保存在这里。
For example, non-unique element names can keep you from properly evaluating code that performs fewer index look-ups.
例如,非唯一元素能够阻止您正确评估执行较少索引查询的代码。
"It's a non-trivial matter to build your own index ofEnglish pages, so why not partner with someone who already does thatwell? " said Kaiser Kuo, a spokesman for Baidu.
百度发言人郭怡广表示,“创建自己的英文页面索引是件不平凡的事情,所以为什么不和某个做得好的人合作呢?
While it may seem that the access plan in Figure 5 is simpler, it comes with a higher estimated execution cost because no index could be exploited to filter out non-qualifying rows.
虽然看上去图5中的访问计划更简单,但是它的预计执行成本更高,因为不能利用索引过滤不符合要求的行。
If a site has too many non-working video links or page after page of video spam, the site won't be included in the search index.
我们的搜索索引不会收录含有太多无效视频链接或低质量视频的网站。
There are two types of Primary Indexes - unique Primary Index (UPI) and Non-unique Primary Index (NUPI).
有两种主索引—惟一主索引(upi)与非惟一主索引(NUPI)。
Non-matching index scan (IXSCAN)
非匹配索引扫描 (IXSCAN)
In the thesis we only count the failure that leads the transformer to quit operation, regarding the transformer as Non-repairable system whose main index is failure rate.
本文只统计造成变压器必须退出运行的故障,研究这类失效应把变压器看成是不可修复系统,其最主要的指标是失效率。
The thesis only counts the failure that leads the transformer to quit operation, regarding the transformer as Non-repairable system whose main index is failure rate.
本文只统计造成变压器必须退出运行的故障,研究这类失效应把变压器看成是不可修复系统,其最主要的指标是失效率。
Individual piece of a non-partitioned index.
非分区索引的单个索引。
Then, you can define one XML index on the non-leaf element "phone" and one on the element "areacode".
然后,可以在非末端元素“phone”和元素“areacode”上分别定义一个xml索引。
Index options like UNIQUE and CLUSTER, and access methods like B-Tree, R-Tree and user-defined access methods can apply to both functional and non-functional indexes.
诸如unique和CLUSTER等索引选项,以及B -Tree、r -Tree等访问方法和用户定义的访问方法,可以同时应用于函数索引和非函数索引。
If you start with a general index you will find articles about new trends, opinions, and information for the non-specialist.
如果你从一个综合的索引开始你将会找到提供给非专业人士的关于新的趋势,意见,和信息的文章。
The answer to the question as stated in your subject line in general is no. Because you generally would much prefer to have the narrowest covering (probably non-clustered) index.
这个问题的答案所你的主题一般是否定的。因为你通常可能更倾向于有窄覆盖(可能非集群)指数。
The method above can also be used to calculate the pore structure index of non-fractured reservoir.
该方法也可以应用于非裂缝性储集层确定孔隙结构指数。
The measures for calculating the index above shall be accorded with the relevant provisions of the CBRC on non-onsite statement index monitoring system.
有关监管指标的计算方法遵照银监会非现场监管报表指标体系的有关规定。
Researchers found that the average user of food stamps had a Body Mass Index (BMI) 1.15 points higher than non-users.
研究发现食物券使用者的平均身体质量指数要比非使用者高1.15。
The performance evaluation of corporate mergers and acquisitions and foreign scholars commonly uses index of non-normal earnings and accounting empirical study.
国内外学者对企业并购的绩效评价通常采用非正常收益法和会计指标法进行实证研究。
Secondly, more attention focus on non - finance index which can raise the enterprise's long-term core ability, such as customer satisfaction, employee's satisfaction and an inferior rate etc.
第二、将更多的注意力集中在具有“前瞻性”的、有助于培植企业长期核心能力的非财务指标之上,诸如顾客满意度、员工满意度和次品率等。
应用推荐