Wednesday, March 20, 2013


DB2 Memo

Structure low - > high

Physical Page * 4 ( or * 8) = Extent * 1
Multi Extent = Table * 1

!! 1 Extent only contain 1 Table data !!


normal table with Single dimensional Clustering only can be sort by 1 column. ( command: organie by (column1) )
Multidimensional Clustering Table can be sort by more thane 1 column. ( command: organie by (column1,column2,..,columnX) )
Multidimensional Clustering Index will automatic create when Table create.

No comments: