But be careful with this tactic; you do not want to replicate a table in an index by including all of the table's columns in the index key.
但是要小心使用这一策略;您并不想以在索引键中包含数据表所有列的方式在索引中复制一个表。
With this feature, the query optimizer can immediately consider the index when determining an access plan.
有了这个特性,查询优化器可以在决定访问计划时立即考虑索引。
This new command allows you to collect statistics and build an index in a single pass of the base table, instead of two passes with the previous implementation of these features.
这条新命令允许您在对基表的一次扫描中收集统计数据,并构建索引,而不像这些特性的以前实现那样需要进行两遍扫描。
This was a well-run study, looking at 307 people with a body mass index of 30 to 40 (classed as obese).
该研究进展顺利,看到307名研究对象的体重指数在30到40之间(按肥胖等级分类)。
This is configured with the same directory where the index files were created earlier.
其配置的目录与前面创建索引文件的目录相同。
The reason for this is that the other tables in the DB2 UDB SAMPLE database have no primary key, and hence no index information to associate a unique ECO key with.
原因是DB2UDBSAMPLE数据库中的其他表没有主键,因此没有索引信息可以关联惟一的ECO 键。
A reset is necessary because, with this method, parsing begins at the ParsePosition index within the input string.
重置很必要,因为使用此方法时解析开始于输入字符串的ParsePosition索引。
The latest instalment, published this week, showed the index had fallen by 0.6% in October compared with the previous month.
这周发布的最新数据显示10月该指数对比前一个月降低了0.6%。
Good enough, but about all you can do with this structure is set and retrieve elements by individual (multi-dimensional) index. In contrast, a Numarray array is a bit more flexible.
很好,但是您对这种结构所能做的只是通过单独的(或者多维的)索引来设置和检索元素。
Testing this system over the period 1996-2007 produces returns that beatthe S&P500 index by more than a percentage point a year with similarvolatility.
这套系统测试1996-2007年期间,在相似的波动性之下,所产出的回报每年平均超过标准普尔指数1个多百分点。
The update for the index statistics would fail with a SQL1227N rc=8 error message (in this case) as the FIRSTKEYCARD of the index is greater than CARD of the table.
对于索引统计数据的更新将失败,并发出 SQL1227Nrc=8错误消息(本例中),因为索引的FIRSTKEYCARD大于表的CARD。
The Vector with index 0 in this super-Vector contains the names of each GUI control participating in the implementation.
此超级vector索引为0的Vector包含了每个参与实现的GUI控件的名称。
I continued with this method, which also created an index of items.
我继续使用这个方法,还编制了一个物品索引。
With this last step, your index for the multiline field is complete.
还有最后一个步骤,您的多行文本域索引就完成了。
With a very small example such as this one, the index can be close to as big as the example as if there were no duplicated words.
使用像本例这样非常小的示例,如果没有重复的单词,则索引的大小会十分接近示例的大小。
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不会对非索引考虑这个因素;只有您能够考虑这个因素并相应编码。
It would be foolish to replace this successful partnership process with a mere mechanical index.
用机械的指数来替代这一成功的合作过程,将是愚蠢的。
This means the actual URL will be stored along with the index, and will be retrievable when you search the index later.
这意味着实际的URL将同该索引一起存储,并且当随后搜索该索引时能够获取它。
In this year's index, the Netherlands and Switzerland earn the highest scores, with Dutch and Swiss companies seen as least likely to bribe abroad.
在今年的排行榜中,荷兰和瑞士得分最高。这表明荷兰和瑞士的公司在海外营业时行贿的可能性最小。
For this purpose, an indexed column is any single column with an index or the first column named in a composite index.
为此,索引列是一个包含索引的单列,或者是复合索引中指定的第一个列。
So why is the MSCI World index of global equities down by more than 10% this year, with emerging markets showing double-digit losses and European bourses shedding more than 20% in dollar terms?
那么,为什么摩根·士丹利资本国际指数今年已下挫逾10%,新兴市场的损失达到两位数,若以美元计价的话,欧洲交易所的市值更是流失了超过20% ?
This type means that the data will be indexed as usual, but it will not be stored along with the index, so it won't be retrievable from a matching result.
这种类型意味着将以通常的方式对数据进行索引,数据不必同索引一起存储,所以不能在匹配的结果中获得该数据。
With the miners making up such a large proportion of the FTSE 100, the index has jumped by as much as 48 points this morning to 5344.72.
由于在英国富时100指数中,矿业股占据相当大的比例,因此,富时100指数今天早上上涨最高达48点,达5344.72。
Figure 17 shows the index recommendations for the sample query in this article, together with an estimated performance improvement and DASD space requirement.
图17显示了本文中查询样例的索引建议,以及估计的性能提升和DASD空间需求。
U.S. stocks climbed, with the Standard &Poor’s 500 Index rebounding from the biggest selloff this month amid optimism about earnings from companies such as Halliburton Co.
周一美股早盘走高,创下本月最大跌幅的标准普尔500指数开始反弹,投资者对哈里伯顿等公司财报情绪乐观。
If you run this code with a larger number for the Fibonacci sequence index (say, 12), you'll end up watching output scroll by for a long time.
如果对大的斐波纳契数列(比如说12)使用这段代码,将会看到长时间的滚动输出。
This section will deal with conversion issues that come up with DDL statements, like table and index creation statements.
本节讨论ddl语句(比如表和索引创建语句)面对的转换问题。
The stock — which is still hovering around the same level it was five years ago — is down 15 percent this year, compared with a 1 percent fall in the Nasdaq composite index.
五年前微软股票就在相同的水平上徘徊——与纳斯达克综合指数下降1%相比,该股票今年下降15%。
The shares are little changed this year, down 0.6 percent compared with a 0.95 percent decline for the Standard & Poor’s 500 Index.
今年的股份基本没变,与标准普尔500种股票指数下降了0.95%来比,它只是下降了0.6%。
The shares are little changed this year, down 0.6 percent compared with a 0.95 percent decline for the Standard & Poor’s 500 Index.
今年的股份基本没变,与标准普尔500种股票指数下降了0.95%来比,它只是下降了0.6%。
应用推荐