if you define a cluster index, then it will do cluster at the one you defined...
or if it's MDC, it will cluster the data at the dimention you defined
otherwise if it's not MDC and there's no clustered index defined, it will not do any data cluster
多谢wangzhonnew
再请教一下,在网上看到了这个
In DB2 for z/OS,the first index defined is the clustering index unless another index is
explicitly defined as the clustering index.
这种说法对么?
原帖由 wangzhonnew 于 2008-7-8 01:56 发表
if you define a cluster index, then it will do cluster at the one you defined...
or if it's MDC, it will cluster the data at the dimention you defined
otherwise if it's not MDC and there's no clustered index defined, it will not do any data cluster