Q: Why can't I specify a table space for my local index using the CREATE index statement?
Q：为什么我无法利用CREATEindex语句为我的本地索引指定表空间？
Q: Can the local index partition and data partition be in the same table space for each partition?
Q：每个分区的本地索引分区和数据分区能否处于同一表空间中？
This is also why maintenance operations like REORG cannot be performed on an individual local index.
这也是无法对单个本地索引执行类似 REORG维护操作的原因。
Global indexes preserve the order property from index scans, and this gives them an edge over local indexes.
全局索引保留来自索引扫描的顺序属性，这是相对于本地索引的一个优势。
However, with local index scans, a partition needs to be locked first to do the index look-up and find a match.
然而，对于本地索引扫描，需要锁定的分区首先要做索引搜索并发现匹配。
Therefore, some partitions that do not contribute any rows for query processing are still locked when accessed via local index.
因此，在利用本地索引进行访问时，那些行与查询处理无关的分区仍被锁定。
For instance, the purchaseOrders table is partitioned by po_date and has a local index on po_customer, the query below will need a sort after the index scan.
例如，表purchaseorders通过po_date进行了分区，并具有本地索引po_customer，以下查询在完成索引扫描后还需要进行排序。
A: Yes, in fact this is the default case and many customers choose to do so. The local index will be in a different table space from the associated data partition when.
A：可以，事实上默认情况下就是如此，并且很多用户都会选择这样做。
Since this local index build happens only on the newly attached partition and requires very limited logging, SET INTEGRITY is still significantly faster compared to global indexes.
因为只在新附加分区上构建这一本地索引，并需要非常有限的日志，所以与全局索引相比，SETINTEGRITY甚至明显变快了。
That's why America needs a “justice index” to show how the essential aspects of our local courts are working.
这就是为什么美国需要一个“公正指数”以反映我们当地的法院主要在做什么工作。
That's why America needs a "justice index" to show how the essential aspects of our local courts are working.
这就是为什么美国需要一个“公正指数”以反映我们当地的法院主要在做什么工作。
The two local predicates cannot benefit from matching or screening index scans from any of the existing indexes.
两个本地谓词无法从匹配或筛选现有的索引扫描中获益。
Q: Why is the size of a global index significantly larger than if the same index was local?
Q：为何全局索引的大小明显比相同的本地索引大？
Actually, they are the index Numbers returned by my query to my local copy of the WordNet database.
实际上，它们是我对我的WordNet数据库本地副本的查询返回的索引数字。
This prevents the changes from showing up in views unless the view index is completely rebuilt (press Shift + F9), and it also causes replication of updates to local replicas to fail.
除非完全重建视图索引(按Shift +F9)，否则这样将阻止变更出现在视图中，而且还会导致将更新复制到本地副本的操作失败。
Since MQTs are local tables that cache the results of a query, the same considerations for creating an index on a local table apply to creating indexes on MQTs.
因为MQT是缓存查询结果的本地表，所以在本地表上创建索引的相同步骤也可应用于在 MQT 上创建索引。
In this case, the local host server ACTS as the host of the index service as well.
在本例中，本地的主机服务器也用作索引服务的主机。
We have strong panel of speakers with local and international experience in the creation of index and financial products.
我们拥有一个阵容强大的演讲小组，他们都在指数和金融产品的创造方面拥有本地和国际经验。
Party A shall be according to company performance, local price index, and the performance of staff personal and work group, make the appropriate adjustment for the salary.
甲方将根据公司的经营状况，地方的物价指数，员工个人及工作小组的表现，每年对乙方的工资作适当的调整。
The residual index analysis method of geographic, geomorphic and geologic linear bodies was used to detect the local structures of petroleum reservoir.
该方法要点是利用地理、地貌及地质的线性体偏差指数分析法预测油气田的局部构造。
Application of residual index of linear bodies to detect the local structure of petroleum reservoir.
应用遥感线性体偏差指数法预测油气藏的局部构造。
Discusses the selections of environmental assessing index and action part of local exposure, and points out the future research directions.
讨论了局部热暴露环境评价指标的选取和局部热暴露作用部位的选择，并指出了今后的研究方向。
The method of determining the index for predicting local roof fall has been given, the possibility of using a comprehensive index for roof weighting prediction has been discussed in detail.
初步给出了局部冒顶监报指标的确定方法；重点探索了采用回采工作面来压综合判断指标来预报顶板来压的可能性。
An index within the gradient information of the arc voltage on the local region of zero can reflect fault location effectively.
含有电弧电压在零区梯度信息的指标可以有效地反映故障位置。
The third part is the advanced warning mechanism and appraisement control index system of local fiscal risk which is regarded as having directly realistic meaning.
第三部分为地方财政风险的预警机制与评价控制指标体系。
This paper introduced the choice of raw material, processing technology, operating rules and product quality index of local black melon seeds.
介绍了以黑瓜子为主料制作风味瓜子时原辅料的选择、生产工艺、操作要点和产品质量指标。
While the local economy began to recover, the rental index increased, and the housing affordability ratio and the real wage index dropped.
在经济开始复苏的同时，租金指数上升，港人的房屋负担能力及实质工资则比前一年下跌。
According to the date obtained the mortality from various diseases of silicotics were calculated and compared with age specific death rate of local residents using SMR as index.
计算矽肺患者各类疾病死亡率，与当地居民的年龄别死亡率进行比较，计算标化死亡比；
The MSCI Pacific ex Japan index rose 0.7% in USD but 0.2% in local currency terms.
摩根士丹利太平洋（日本除外）指数以美元计升0.7%，以当地货币计则升0.2%。
The critical loads resulting in the local trivial dent in the center of the shallow shell is regarded as the important index for the lightweight of the automobile parts.
根据扁壳中心局部产生微凹痕的临界外载荷作为汽车扁平类零件在轻量化过程中的一项重要指标。
应用推荐