银行online
6同行回答
应该是可以在线创建的，但是建议在业务低谷的时候操作
另，新建索引后，必须runstats，才能被Db2优化器识别，这个很重要收起
另，新建索引后，必须runstats，才能被Db2优化器识别，这个很重要收起
浏览1218
一般肯定在业务低峰建索引。。。 建索引的最后一刻，会加读锁，如果表非常大，肯定影响业务一下下 ...ysgift 发表于 2014-1-30 20:03
Agree.It is common practice/wisdom to do large index creation during less busy hours or maintenance window....Agree.
It is common practice/wisdom to do large index creation during less busy hours or maintenance window.收起
浏览1246
see the highlighted below:
Notes
Concurrent read/write access to the table is permitted while an index is being created, except when the EXTEND USING clause is specified. However, the default index creation behavior differs for indexes on nonpartitioned tables, nonpartitioned indexes, and partitioned indexes:
For indexes on nonpartitioned tables, once the index has been built, changes that were made to the table during index creation time are forward-fitted to the new index. Write access to the table is then briefly blocked while index creation completes, after which the new index becomes available.收起
Notes
Concurrent read/write access to the table is permitted while an index is being created, except when the EXTEND USING clause is specified. However, the default index creation behavior differs for indexes on nonpartitioned tables, nonpartitioned indexes, and partitioned indexes:
For indexes on nonpartitioned tables, once the index has been built, changes that were made to the table during index creation time are forward-fitted to the new index. Write access to the table is then briefly blocked while index creation completes, after which the new index becomes available.收起
浏览1184
浏览1199
unlike MySQL, db2 index creation is online
http://pic.dhe.ibm.com/infocente ... doc%2Fr0000919.html收起
http://pic.dhe.ibm.com/infocente ... doc%2Fr0000919.html收起
浏览1289