在不锁定表的情况下创建和删除索引。
可以添加或删除索引。
要想进行更改,必须删除索引,然后重新创建它。
You would need to drop the index and create it again in order to implement changes.
结果我们比以前多了很多的表,但添加和删除索引却很容易。
As a result, we end up having more tables than we had before, but adding and removing indexes is easy.
表示呼叫位置上的动态删除索引作业,并提供系结语意和作业详细资料。
Represents the dynamic delete index operation at the call site, providing the binding semantic and the details about the operation.
可以添加和删除索引;通过删除、改名或添加列来修改表;甚至在必要的时候借助于SQL。
You can add and drop indexes; alter tables by dropping, renaming, or adding columns; and even drop down into SQL as necessary.
如果您决定删除索引,那么首先要保存它的CREATEindex语句,以便在需要时轻松地重新创建它。
If you do decide to drop an index, you should first save its create index statement so that you can easily recreate it if necessary.
这个脚本将会提示您要么删除现存的索引,要么创建一个新的索引。
This script will prompt you to either delete the existing index or create a new index.
它提供在索引中添加、删除和更新文档的方法。
It provides methods to add, delete, or update documents in the index.
因为增量索引可以添加和删除条目,所以多个执行任务可导致重复或丢失项。
As incremental indexing can add and delete entries, multiple executing tasks can lead to duplicate or missing entries.
如果从一个带有10个索引的表删除一行,DB 2必须删除与被删除的行关联的所有索引条目。
Delete a row from a table with 10 indexes, and DB2 must remove all index entries associated with the deleted rows.
您可以根据通过这些方法获得的信息删除不需要的索引。
Based on that information, you can delete indexes that are not required.
该接口用来实现从索引目录中定制删除过时提交的策略。
An interface used to implement a policy to customize deletion of stale commits from the index directory.
DB 2V8.2.2中这种新的DELETE算法可以显著减少与mdc表中行及其相应的块索引的删除相关的日志记录和处理。
This new DELETE algorithm in DB2 V8.2.2 can drastically reduce the logging and processing associated with the deletion of rows in an MDC table and its corresponding block indexes.
注意:使功能失效要在删除所有索引之前进行,如果需要可以取消用户帐户权限,这样就不会导致用户的错误。
Note: Disabling the feature should be done before dropping all indexes and if desired, revoking permissions of the user account, so that no user errors will result.
以其他方式修改数据库,包括添加、删除或修改索引或其他约束。
Changing the database in other ways, including adding, dropping, or modifying indexes or other constraints.
不要添加了新索引,又保留已有的索引,或者仅仅是删除了已有的索引。
Don't add the new index and keep the existing one or simply drop the existing index.
那意味着,无论何时添加或删除分区,都必须在分区表的所有现有索引中添加或删除对应记录。
This meant that whenever partitions were added or removed, corresponding records had to be added to or removed from any indexes that existed for the table.
更糟的是,GAE没有提供简单的方式来删除不再使用的索引。
Making matters worse, GAE provides no easy way to delete indexes that are no longer in use.
因此,在决定是否删除当前未使用的索引时,一定要仔细考虑。
So be cautious when deciding whether or not to drop an index that appears not to be used.
这说明,在创建或删除函数索引时,执行索引的表中始终持有一个排他锁。
This means that an exclusive lock is always placed on the indexed table while a functional index is being created or dropped.
在图6显示的下一个面板中,建议表明有些索引可以删除。
On the next panel, shown in Figure 6, the recommendations show there are indexes that can be dropped.
这些冲突操作包括:压缩、重新打包、收缩、更改、在线索引构建、截断、以及删除。
These conflicting operations include: compress, repack, shrink, alter, online index build, truncate, and drop.
SIAPI为只读的,不含有任何添加、删除或修改搜索索引的方法。
The SIAPI is read-only and does not contain any methods for adding, removing, or changing the search index.
这样会留下大量的删除存根(stub),从而减慢了索引和复制。
This leaves a lot of deletion stubs behind, which slows view indexing and replication.
IndexWriter允许用户指定可选索引删除策略。
IndexWriter lets users specify an optional index deletion policy.
而EMF的ChangeDescription接口还可以提供更具体的信息,如“删除某个索引位置的雇员”,这就有用得多。
EMF's ChangeDescription interface, on the other hand, also provides more precise information, such as "remove employee at some index," which would be much more useful.
在config - wcm - repository任务期间,WPSconfig . sh删除现有索引。
WPSconfig.sh will remove the existing indexes during the config-wcm-repository task.
B -TreeScanner自动判断哪些索引项应该删除。
The B-Tree Scanner automatically determines which index items are to be deleted.
B - TreeScanner线程会去掉删除的索引项并重新平衡索引节点。
The B-Tree Scanner threads remove deleted index entries and rebalance the index nodes.
应用推荐