The granularity of locking used on an index can be set using the CREATE INDEX and ALTER INDEX statements.
指定的索引名称必须与当前的现有索引相同;但可以修改索引定义。
SQL described tables and indexes can also be placed and moved by the corresponding ALTER TABLE or ALTER INDEX commands.
SQL描述的表和索引也可以通过对应的ALTERTABLE或 ALTER INDEX命令放置和移动。
An automatic index update can be specified as an index attribute during the index creation or specified later using an alter index command.
自动索引更新可以在创建索引时用索引属性指定,也可以以后使用alter index命令指定。
Also, once an index has been created in DB2, you cannot alter any clause of the index definition.
此外,在DB 2中,一旦创建了索引,就不能修改索引定义中的任何子句。
These conflicting operations include: compress, repack, shrink, alter, online index build, truncate, and drop.
这些冲突操作包括:压缩、重新打包、收缩、更改、在线索引构建、截断、以及删除。
New syntax for disabling an index for foreign key constraint was added to use with the ALTER statement.
用于为外键约束禁用索引的新语句被使用alter语句添加来使用。
The replay position advancement is necessary because the slow alter, alter fragment, and clustered index creation operations change the table partition Numbers.
重放位置的推进是必需的,因为slowalter、alterfragment和集群索引创建操作会改变表分区号。
For the slow alter, alter fragment, or clustered index creation operations, the alter operation replay position is moved to the current log position before performing the operation.
对于slowalter、alter fragment或集群索引创建操作,在执行alter操作之前,alter操作的重放位置被移动到当前的日志位置。
Some operations like ALTER table require no cursor to be open, while others like CREATE INDEX ONLINE allow cursors on the table.
ALTERTABLE等一些操作要求不打开游标,而CREATEINDEXONLINE等其它操作则允许表上的游标。
Your database user needs quite a lot database permissions, including alter table, drop table, same for index etc.
数据库用户需要相当多的权限,包括修改表格,放下表格,索引一类的也一样。
Your database user needs quite a lot database permissions, including alter table, drop table, same for index etc.
数据库用户需要相当多的权限,包括修改表格,放下表格,索引一类的也一样。
应用推荐