表索引有组织吗？ [英] table index organized ?
问题描述
如果知道某个特定的表是否按索引排序，哪一个
一个？
reorg table index ind1 - >桌子由ind1组织
i不知道所有的桌子
thx
Jean写道：
如果知道特定的表是否按索引组织，哪一个？
reorg table index ind1 - >桌子由ind1组织
我不知道所有的桌子
看看SYSSTAT.INDEXES.CLUSTERRATIO和CLUSTERFACTOR。
如果您使用ORGANIZE BY KEY
SEQUENCE选项定义了范围集群表，请查看SYSCAT.INDEXES.INDEXTYPE。它将包含
RCT对于这样的表格。
-
Knut Stolze
信息集成
IBM德国/大学of Jena
" Jean" < TE ** @ est.com>在留言新闻中写道：< 38 ************************************** @ pro xyusinor。 usinor.com> ...
如果知道某个特定的表是否按索引组织，哪个
一个？
reorg table index ind1 - >桌子由ind1组织
我不知道所有的桌子
thx
如果其中一个索引被定义为聚集而且那么DB2将使用它来在重组期间和插入期间对行进行排序。
如果没有将索引定义为聚簇，则必须指定索引
在重组时订购表行，并且DB2在任何地方插入
方便的表格。
< blockquote>>
如果其中一个索引定义为clustered，则那么DB2将使用它在重组期间和插入期间对行进行排序。
如果没有将索引定义为集群，则必须在重组时指定索引
订购表行，并将DB2插入到表中的任何地方都很方便。
i不明白
示例：
table1有3个索引：index1，index2，index3
i发出以下命令
db2 reorg table table1 index index2
之后，我怎样才能检索到表已经使用
index2重新组织了
我认为现在index2是一个集群索引？
如果是，：db2 v7中的
，如何重新组织所有索引而不发出所有这些命令
：
db2 reorg table table1 index index1
db2 reorg table table1 index index2
db2 reorg table table1 index index3
Hi,
how to know for a particular table if it is organized by index, and which
one ?
reorg table index ind1 -> the table is organised by ind1
i wan''t to know that for all table
thx
Jean wrote:
Hi,
how to know for a particular table if it is organized by index, and which
one ?
reorg table index ind1 -> the table is organised by ind1
i wan''t to know that for all table
Have a look at SYSSTAT.INDEXES.CLUSTERRATIO and CLUSTERFACTOR.
And if you have range clustered tables defined using the ORGANIZE BY KEY
SEQUENCE option, have a look at SYSCAT.INDEXES.INDEXTYPE. It will contain
"RCT" for such tables.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
"Jean" <te**@est.com> wrote in message news:<38**************************************@pro xyusinor.usinor.com>...Hi,
how to know for a particular table if it is organized by index, and which
one ?
reorg table index ind1 -> the table is organised by ind1
i wan''t to know that for all table
thx
If one of the indexes is defined as "clustered" then DB2 will use it
to order rows during a reorg and during an insert.
If no index is defined as clustered, then an index must be specified
at time of reorg to order the table rows, and DB2 inserts wherever in
the table it is convenient.
>If one of the indexes is defined as "clustered" then DB2 will use it
to order rows during a reorg and during an insert.
If no index is defined as clustered, then an index must be specified
at time of reorg to order the table rows, and DB2 inserts wherever in
the table it is convenient.
i don''t understand
example :
table1 has 3 indexes : index1, index2, index3
i issue the following command
db2 reorg table table1 index index2
after that, how can i retrieve the table has benn reorganised by using the
index2
I think that now index2 is a cluster index ?
If yes, :
in db2 v7, how can i reorganise all index without issuing all these commands
:
db2 reorg table table1 index index1
db2 reorg table table1 index index2
db2 reorg table table1 index index3
这篇关于表索引有组织吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
