我看了下这个啊(实验环境)查看到表call_type的信息如下:你说的这些东西是如何调整啊?你给的答案方向很明确,步骤我不是很懂啊。。。。TBLspace Report for sales_demo:informix.call_type Physical Address ...
显示全部我看了下这个啊(实验环境)
查看到表call_type的信息如下:
你说的这些东西是如何调整啊?
你给的答案方向很明确,步骤我不是很懂啊。。。。
TBLspace Report for sales_demo:informix.call_type
Physical Address 1:3109
Creation date 02/12/2012 12:03:29
TBLspace Flags 801 Page Locking
TBLspace use 4 bit bit-maps
Maximum row size 31
Number of special columns 0
Number of keys 0
Number of extents 1
Current serial value 1
Current SERIAL8 value 1
Current REFID value 1
Pagesize (k) 2
First extent size 8
Next extent size 8
Number of pages allocated 8
Number of pages used 2
Number of data pages 1
Number of rows 6
Partition partnum 1049111
Partition lockid 1049111
Extents
Logical Page Physical Page Size Physical Pages
0 1:3879 8 8
Index 106_17 fragment partition rootdbs in DBspace rootdbs
Physical Address 1:3110
Creation date 02/12/2012 12:03:29
TBLspace Flags 801 Page Locking
TBLspace use 4 bit bit-maps
Maximum row size 31
Number of special columns 0
Number of keys 1
Number of extents 1
Current serial value 1
Current SERIAL8 value 1
Current REFID value 1
Pagesize (k) 2
First extent size 4
Next extent size 4
Number of pages allocated 4
Number of pages used 2
Number of data pages 0
Number of rows 0
Partition partnum 1049112
Partition lockid 1049111
Extents
Logical Page Physical Page Size Physical Pages
0 1:3887 4 4
WARNING: index check requires a s-lock on tables whose lock level is page.
收起