DBCC使用之：使用DBCC来探索ASE中的索引页及数据页结构

来源：互联网发布：什么软件找工作最好编辑：程序博客网时间：2024/04/28 13:36

可能要用到的DBCC指令：

1> dbcc help(log)
2> go
log( [dbid | dbname] [,objid | objname] [,page] [,row] [,nrecords] [,type={
-1..84 }] ,printopt={ 0 | 1 | 2 | 3 } [,indid | indname] [,ptnid | ptnname] )
1> dbcc help(page)
2> go
page( dbid|dbname, pagenum [, printopt={0|1|2|3|4} [, cache={0|1} [,
logical={1|0} [, cachename | -1 ]]]] )
1> dbcc help(listoam)
2> go
listoam(dbid | dbname, objid | objname, indid | indname [, ptnid | ptnname [,
cache=[1]{ 1 | 'cache' | 0 | 'disk' } [, printopt=[1]{ 1 | 'verbose' | 0 |
'terse' } ] ] ])

我们用下述SQL来造数据：

1> create table mytest(id int primary key, col2 varchar(512))2> go1> create index idx_mytest_col2 on mytest(col2)2> go1> insert into mytest values(1, replicate(char(convert(int, round(rand() * 26, 0) + 65) ), 512))2> go(1 row affected)1> insert into mytest values(2, replicate(char(convert(int, round(rand() * 26, 0) + 65) ), 512))2> go(1 row affected)1> insert into mytest select id + (select max(id) from mytest), replicate(char(convert(int, round(rand() * 26, 0) + 65) ), 512) from mytest2> go 10(1024 rows affected)10 xacts:

Sysindexes系统表的关键列：

以上是准备工作，我们再看看sysindexes的列含义：

id, 表的ID，或者index所属的表的id
indid, 索引ID，值为0时，它是一个表。为1时，为APL表的聚簇索引(cluster index)，>1时，为非聚簇索引或者是DOL表上的聚簇索引
为255时，指代的是LOB结构
doampg, 表的对象分配页上对象的页号
ioampg，索引或者LOB结构的分配页号
first, 如果indid为0或1，数据页的首页号, 如果是2到250，它为页级索引页的第一个页号
root, 如果indid为0，并且表是未分区的APL表，它是页链的最后一页的页号。如果是1到250之间，它是索引树的根的页号。

Syspartitions的关键列：
indid, id同上。
partitionid, 索引或数据的分区ID
segment，段号
datoampage
indoampage
firstpage
rootpage
含义同上。

获取索引相关信息：

1> select id, indid, doampg, ioampg, first, root from sysindexes where id = object_id('mytest')2> go id          indid  doampg      ioampg      first       root ----------- ------ ----------- ----------- ----------- -----------   960003420      1           0           0           0           0   960003420      2           0           0           0           0(2 rows affected)

1> select name, indid, segment, datoampage, indoampage, firstpage, rootpage from syspartitions where id = object_id('mytest')2> go name         indid  segment datoampage  indoampage  firstpage   rootpage ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------         ------ ------- ----------- ----------- ----------- ----------- mytest_id_9600034201_960003420              1       1         968         960         969         961 idx_mytest_col2_960003420              2       1           0         872         874         873(2 rows affected)

据此分析，索引mytest_id_9600034201_960003420是聚簇索引，首页号为969, 根页号为961.
索引idx_mytest_col2_960003420为非聚簇索引，首页号为874, 根页号为873.

表mytest总共有2048行数据，

1> select count(*) from mytest2> go -----------        2048(1 row affected)

1> select pagesize(object_id('mytest'))2> go -----------        4096(1 row affected)

看看对象分配页的情况：

1> dbcc listoam('iihero', 'mytest', 1)2> go-----------------------------------------------------------------------------Partition id:  960003420     indid:   1 prevpg: 960 nextpg: 960OAM pg cnt:      1      Entry cnt:          1Row count information is not maintained for index pages.Used pgs:        2      Unused pgs:         6Attribute entries:       10OAM status bits set:  (0x8000 (PG_OAMPG), 0x0008 (PG_OAMATTRIB), 0x0004(PG_OAMSORT))LAST SCANNED OAM PAGE:          0ALLOCATION HINTS     :         0          0          0          0         0          0          0          0         0          0          0          0         0          0          0OAM pg #  1:        960 has the following 1 entry (allocpg:used/unused):[   0]        768:  2/  6        ---- End of OAM chain for partition 960003420 ----

1> dbcc listoam('iihero', 'mytest', 2)2> go-----------------------------------------------------------------------------Partition id:  960003420     indid:   2 prevpg: 872 nextpg: 872OAM pg cnt:      1      Entry cnt:          8Row count information is not maintained for index pages.Used pgs:      576      Unused pgs:         6Attribute entries:       10OAM status bits set:  (0x8000 (PG_OAMPG), 0x0008 (PG_OAMATTRIB))LAST SCANNED OAM PAGE:          0ALLOCATION HINTS     :       872          0          0          0         0          0          0          0         0          0          0          0         0          0          0OAM pg #  1:        872 has the following 8 entries (allocpg:used/unused):[   0]        768: 24/  0        1024: 88/  0        1280: 72/  0        1536:111/  0[   4]       1792: 48/  0        2048:104/  0        2304:104/  0        2560:25/  6        ---- End of OAM chain for partition 960003420 ----

以普通索引2为例，

1> dbcc page('iihero', 873, 1)2> goPage found in Cache: default data cache. Cachelet: 1BUFFER:Buffer header for buffer 0x22D55000    page=0x22D54000 bdnew=0x23588550 bdold=0x23588550 bhash=0x23587E00    bmass_next=0x23588310 bmass_prev=0x23596C80 bdbid=4    bvirtpg=[ 0x22D55078 vpgdevno=5 vpvpn=1746 vdisk=0x214E04C8 ]    bmass_head=0x23588550 bmass_tail=0x23588550    bcache_desc=0x22D57C00 (cid=0 cache name='default data cache')    bpool_desc=0x22D59BF4 bdbtable=0x20EBBC60    Mass bkeep=0 Mass bpawaited=0 Mass btripsleft=0 Mass btripsleft_orig=0    bmass_size=4096 (4K pool) bunref_cnt=0    bmass_stat=0x86001010(0x0000000080000000 (MASS_FLUSHED), 0x0000000004000000(MASS_DONT_DISCARD), 0x0000000002000000 (MASS_WRITE_BY_HK), 0x0000000000001000(MASS_HASHED), 0x0000000000000010 (MASS_INWASH))    bbuf_stat=0x1 (0x00000001 (BUF_PG_REF))    Buffer blpageno=873 bpg_size=4k Mass blpageno=873 Mass blocallockkeep=0bxls_pin=0x00000000 bxls_next=0x00000000 bspid=0    bxls_flushseq=0 bxls_pinseq=0 bcurrxdes=0x00000000Latch and the wait queue:Latch (address: 0x22D55024)        latchmode: 0x0 (FREE_LATCH)        latchstatus: 0x0        latchowner: -1        latchnoofowners: 0        latchwaitq: 0x00000000  latchwaitqt: 0x00000000        latchlastfileindex=0 (nofilename) latchlastlineno=0Latch wait queue:PAGE HEADER:Page header for page 0x22D54000pageno=873 nextpg=0 prevpg=0 ptnid=960003420  timestamp=0000 000039b3lastrowoff=2677 level=4 indid=2 freeoff=3206 minlen=11page status bits: 0x1000 (0x1000 (PG_OFFSET))DATA:Offset 32 - row length=529 # varlen cols=1 Child page ID=148222D54020 (     0):  01c90300 000200ca 05000011 02464646  .............FFF22D54030 (    16):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54040 (    32):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54050 (    48):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54060 (    64):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54070 (    80):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54080 (    96):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54090 (   112):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D540A0 (   128):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D540B0 (   144):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D540C0 (   160):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D540D0 (   176):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D540E0 (   192):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D540F0 (   208):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54100 (   224):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54110 (   240):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54120 (   256):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54130 (   272):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54140 (   288):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54150 (   304):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54160 (   320):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54170 (   336):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54180 (   352):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54190 (   368):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D541A0 (   384):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D541B0 (   400):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D541C0 (   416):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D541D0 (   432):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D541E0 (   448):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D541F0 (   464):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54200 (   480):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54210 (   496):  46464646 46464646 46464646 46464646  FFFFFFFFFFFFFFFF22D54220 (   512):  46464646 46464646 46464646 4602020d  FFFFFFFFFFFFF...22D54230 (   528):  0d                                   .Row-Offset table for variable-length columns:        [<varcol number>, <offset from start of the row>, <varcol length>]        [1, 13, 512]Offset 561 - row length=529 # varlen cols=1 Child page ID=250522D54231 (     0):  01ca0300 000100c9 09000011 02444444  .............DDD22D54241 (    16):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54251 (    32):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54261 (    48):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54271 (    64):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54281 (    80):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54291 (    96):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D542A1 (   112):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D542B1 (   128):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D542C1 (   144):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D542D1 (   160):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D542E1 (   176):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D542F1 (   192):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54301 (   208):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54311 (   224):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54321 (   240):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54331 (   256):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54341 (   272):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54351 (   288):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54361 (   304):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54371 (   320):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54381 (   336):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54391 (   352):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D543A1 (   368):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D543B1 (   384):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D543C1 (   400):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D543D1 (   416):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D543E1 (   432):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D543F1 (   448):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54401 (   464):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54411 (   480):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54421 (   496):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54431 (   512):  44444444 44444444 44444444 4402020d  DDDDDDDDDDDDD...22D54441 (   528):  0d                                   .Row-Offset table for variable-length columns:        [<varcol number>, <offset from start of the row>, <varcol length>]        [1, 13, 512]Offset 1090 - row length=529 # varlen cols=1 Child page ID=148322D54442 (     0):  01cf0300 000000cb 05000011 02494949  .............III22D54452 (    16):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54462 (    32):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54472 (    48):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54482 (    64):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54492 (    80):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D544A2 (    96):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D544B2 (   112):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D544C2 (   128):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D544D2 (   144):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D544E2 (   160):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D544F2 (   176):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54502 (   192):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54512 (   208):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54522 (   224):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54532 (   240):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54542 (   256):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54552 (   272):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54562 (   288):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54572 (   304):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54582 (   320):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54592 (   336):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D545A2 (   352):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D545B2 (   368):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D545C2 (   384):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D545D2 (   400):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D545E2 (   416):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D545F2 (   432):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54602 (   448):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54612 (   464):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54622 (   480):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54632 (   496):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54642 (   512):  49494949 49494949 49494949 4902020d  IIIIIIIIIIIII...22D54652 (   528):  0d                                   .Row-Offset table for variable-length columns:        [<varcol number>, <offset from start of the row>, <varcol length>]        [1, 13, 512]Offset 1619 - row length=529 # varlen cols=1 Child page ID=258622D54653 (     0):  01c80400 0006001a 0a000011 024c4c4c  .............LLL22D54663 (    16):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54673 (    32):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54683 (    48):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54693 (    64):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D546A3 (    80):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D546B3 (    96):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D546C3 (   112):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D546D3 (   128):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D546E3 (   144):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D546F3 (   160):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54703 (   176):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54713 (   192):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54723 (   208):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54733 (   224):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54743 (   240):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54753 (   256):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54763 (   272):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54773 (   288):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54783 (   304):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54793 (   320):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D547A3 (   336):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D547B3 (   352):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D547C3 (   368):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D547D3 (   384):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D547E3 (   400):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D547F3 (   416):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54803 (   432):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54813 (   448):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54823 (   464):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54833 (   480):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54843 (   496):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c  LLLLLLLLLLLLLLLL22D54853 (   512):  4c4c4c4c 4c4c4c4c 4c4c4c4c 4c02020d  LLLLLLLLLLLLL...22D54863 (   528):  0d                                   .Row-Offset table for variable-length columns:        [<varcol number>, <offset from start of the row>, <varcol length>]        [1, 13, 512]Offset 2148 - row length=529 # varlen cols=1 Child page ID=176022D54864 (     0):  01ca0300 000200e0 06000011 02505050  .............PPP22D54874 (    16):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54884 (    32):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54894 (    48):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D548A4 (    64):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D548B4 (    80):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D548C4 (    96):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D548D4 (   112):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D548E4 (   128):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D548F4 (   144):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54904 (   160):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54914 (   176):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54924 (   192):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54934 (   208):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54944 (   224):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54954 (   240):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54964 (   256):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54974 (   272):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54984 (   288):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54994 (   304):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D549A4 (   320):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D549B4 (   336):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D549C4 (   352):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D549D4 (   368):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D549E4 (   384):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D549F4 (   400):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54A04 (   416):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54A14 (   432):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54A24 (   448):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54A34 (   464):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54A44 (   480):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54A54 (   496):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54A64 (   512):  50505050 50505050 50505050 5002020d  PPPPPPPPPPPPP...22D54A74 (   528):  0d                                   .Row-Offset table for variable-length columns:        [<varcol number>, <offset from start of the row>, <varcol length>]        [1, 13, 512]Offset 2677 - row length=529 # varlen cols=1 Child page ID=216222D54A75 (     0):  011c0400 00050072 08000011 02555555  .......r.....UUU22D54A85 (    16):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54A95 (    32):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54AA5 (    48):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54AB5 (    64):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54AC5 (    80):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54AD5 (    96):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54AE5 (   112):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54AF5 (   128):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54B05 (   144):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54B15 (   160):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54B25 (   176):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54B35 (   192):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54B45 (   208):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54B55 (   224):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54B65 (   240):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54B75 (   256):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54B85 (   272):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54B95 (   288):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54BA5 (   304):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54BB5 (   320):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54BC5 (   336):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54BD5 (   352):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54BE5 (   368):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54BF5 (   384):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54C05 (   400):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54C15 (   416):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54C25 (   432):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54C35 (   448):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54C45 (   464):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54C55 (   480):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54C65 (   496):  55555555 55555555 55555555 55555555  UUUUUUUUUUUUUUUU22D54C75 (   512):  55555555 55555555 55555555 5502020d  UUUUUUUUUUUUU...22D54C85 (   528):  0d                                   .Row-Offset table for variable-length columns:        [<varcol number>, <offset from start of the row>, <varcol length>]        [1, 13, 512]

这里我们可以看得很清楚，
Row-Offset table for variable-length columns:
        [<varcol number>, <offset from start of the row>, <varcol length>]
        [1, 13, 512]
从第14个字节开始，512个字节的长度为col2的值，一下子就可以看出来了。 不再解释。
前13个字节，应该是存储着字段id的值。待分析。

我们如果接着分析1> dbcc page('iihero', 1696, 1)

就会得到它的子节点，跑到数据页上了。 Offset 32 - row length=525 # varlen cols=1 Data page RID=(1668, 2), 不再列举。
此数据页1668的内容如下：

1> dbcc page('iihero', 1668, 1)2> goPage found in Cache: default data cache. Cachelet: 1BUFFER:Buffer header for buffer 0x22D55000    page=0x22D54000 bdnew=0x235A16F0 bdold=0x235A16F0 bhash=0x235785F0    bmass_next=0x235A2AA0 bmass_prev=0x235785F0 bdbid=4    bvirtpg=[ 0x22D55078 vpgdevno=5 vpvpn=3336 vdisk=0x214E04C8 ]    bmass_head=0x235A16F0 bmass_tail=0x235A16F0    bcache_desc=0x22D57C00 (cid=0 cache name='default data cache')    bpool_desc=0x22D59BF4 bdbtable=0x20EBBC60    Mass bkeep=0 Mass bpawaited=0 Mass btripsleft=0 Mass btripsleft_orig=0    bmass_size=4096 (4K pool) bunref_cnt=0    bmass_stat=0x6001010(0x0000000004000000 (MASS_DONT_DISCARD),0x0000000002000000 (MASS_WRITE_BY_HK), 0x0000000000001000 (MASS_HASHED),0x0000000000000010 (MASS_INWASH))    bbuf_stat=0x1 (0x00000001 (BUF_PG_REF))    Buffer blpageno=1668 bpg_size=4k Mass blpageno=1668 Mass blocallockkeep=0bxls_pin=0x00000000 bxls_next=0x00000000 bspid=0    bxls_flushseq=0 bxls_pinseq=0 bcurrxdes=0x00000000Latch and the wait queue:Latch (address: 0x22D55024)        latchmode: 0x0 (FREE_LATCH)        latchstatus: 0x0        latchowner: -1        latchnoofowners: 0        latchwaitq: 0x00000000  latchwaitqt: 0x00000000        latchlastfileindex=0 (nofilename) latchlastlineno=0Latch wait queue:PAGE HEADER:Page header for page 0x22D54000pageno=1668 nextpg=1669 prevpg=1667 ptnid=960003420  timestamp=0000 000026fcnextrno=7 level=0 indid=0 freeoff=3700 minlen=6page status bits: 0x101 (0x0100 (PG_ADDEND), 0x0001 (PG_DATA))DATA:Offset 32 - row ID=0 row length=524 # varlen cols=122D54020 (     0):  01005e03 00000c02 50505050 50505050  ..^.....PPPPPPPP22D54030 (    16):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54040 (    32):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54050 (    48):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54060 (    64):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54070 (    80):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54080 (    96):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54090 (   112):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D540A0 (   128):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D540B0 (   144):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D540C0 (   160):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D540D0 (   176):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D540E0 (   192):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D540F0 (   208):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54100 (   224):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54110 (   240):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54120 (   256):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54130 (   272):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54140 (   288):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54150 (   304):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54160 (   320):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54170 (   336):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54180 (   352):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54190 (   368):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D541A0 (   384):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D541B0 (   400):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D541C0 (   416):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D541D0 (   432):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D541E0 (   448):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D541F0 (   464):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54200 (   480):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54210 (   496):  50505050 50505050 50505050 50505050  PPPPPPPPPPPPPPPP22D54220 (   512):  50505050 50505050 02020808           PPPPPPPP....Row-Offset table for variable-length columns:        [<varcol number>, <offset from start of the row>, <varcol length>]        [1, 8, 512]Offset 556 - row ID=1 row length=524 # varlen cols=122D5422C (     0):  01015f03 00000c02 44444444 44444444  .._.....DDDDDDDD22D5423C (    16):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5424C (    32):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5425C (    48):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5426C (    64):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5427C (    80):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5428C (    96):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5429C (   112):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D542AC (   128):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D542BC (   144):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D542CC (   160):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D542DC (   176):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D542EC (   192):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D542FC (   208):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5430C (   224):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5431C (   240):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5432C (   256):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5433C (   272):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5434C (   288):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5435C (   304):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5436C (   320):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5437C (   336):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5438C (   352):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5439C (   368):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D543AC (   384):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D543BC (   400):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D543CC (   416):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D543DC (   432):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D543EC (   448):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D543FC (   464):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5440C (   480):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5441C (   496):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D5442C (   512):  44444444 44444444 02020808           DDDDDDDD....Row-Offset table for variable-length columns:        [<varcol number>, <offset from start of the row>, <varcol length>]        [1, 8, 512]Offset 1080 - row ID=2 row length=524 # varlen cols=122D54438 (     0):  01026003 00000c02 44444444 44444444  ..`.....DDDDDDDD22D54448 (    16):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54458 (    32):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54468 (    48):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54478 (    64):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54488 (    80):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54498 (    96):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D544A8 (   112):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D544B8 (   128):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D544C8 (   144):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D544D8 (   160):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D544E8 (   176):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D544F8 (   192):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54508 (   208):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54518 (   224):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54528 (   240):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54538 (   256):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54548 (   272):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54558 (   288):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54568 (   304):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54578 (   320):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54588 (   336):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54598 (   352):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D545A8 (   368):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D545B8 (   384):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D545C8 (   400):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D545D8 (   416):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D545E8 (   432):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D545F8 (   448):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54608 (   464):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54618 (   480):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54628 (   496):  44444444 44444444 44444444 44444444  DDDDDDDDDDDDDDDD22D54638 (   512):  44444444 44444444 02020808           DDDDDDDD....Row-Offset table for variable-length columns:        [<varcol number>, <offset from start of the row>, <varcol length>]        [1, 8, 512]Offset 1604 - row ID=3 row length=524 # varlen cols=122D54644 (     0):  01036103 00000c02 45454545 45454545  ..a.....EEEEEEEE22D54654 (    16):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54664 (    32):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54674 (    48):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54684 (    64):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54694 (    80):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D546A4 (    96):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D546B4 (   112):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D546C4 (   128):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D546D4 (   144):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D546E4 (   160):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D546F4 (   176):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54704 (   192):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54714 (   208):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54724 (   224):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54734 (   240):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54744 (   256):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54754 (   272):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54764 (   288):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54774 (   304):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54784 (   320):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54794 (   336):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D547A4 (   352):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D547B4 (   368):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D547C4 (   384):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D547D4 (   400):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D547E4 (   416):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D547F4 (   432):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54804 (   448):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54814 (   464):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54824 (   480):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54834 (   496):  45454545 45454545 45454545 45454545  EEEEEEEEEEEEEEEE22D54844 (   512):  45454545 45454545 02020808           EEEEEEEE....Row-Offset table for variable-length columns:        [<varcol number>, <offset from start of the row>, <varcol length>]        [1, 8, 512]Offset 2128 - row ID=4 row length=524 # varlen cols=122D54850 (     0):  01046203 00000c02 54545454 54545454  ..b.....TTTTTTTT22D54860 (    16):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54870 (    32):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54880 (    48):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54890 (    64):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D548A0 (    80):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D548B0 (    96):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D548C0 (   112):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D548D0 (   128):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D548E0 (   144):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D548F0 (   160):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54900 (   176):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54910 (   192):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54920 (   208):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54930 (   224):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54940 (   240):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54950 (   256):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54960 (   272):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54970 (   288):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54980 (   304):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54990 (   320):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D549A0 (   336):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D549B0 (   352):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D549C0 (   368):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D549D0 (   384):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D549E0 (   400):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D549F0 (   416):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54A00 (   432):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54A10 (   448):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54A20 (   464):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54A30 (   480):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54A40 (   496):  54545454 54545454 54545454 54545454  TTTTTTTTTTTTTTTT22D54A50 (   512):  54545454 54545454 02020808           TTTTTTTT....Row-Offset table for variable-length columns:        [<varcol number>, <offset from start of the row>, <varcol length>]        [1, 8, 512]Offset 2652 - row ID=5 row length=524 # varlen cols=122D54A5C (     0):  01056303 00000c02 4f4f4f4f 4f4f4f4f  ..c.....OOOOOOOO22D54A6C (    16):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54A7C (    32):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54A8C (    48):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54A9C (    64):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54AAC (    80):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54ABC (    96):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54ACC (   112):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54ADC (   128):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54AEC (   144):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54AFC (   160):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54B0C (   176):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54B1C (   192):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54B2C (   208):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54B3C (   224):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54B4C (   240):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54B5C (   256):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54B6C (   272):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54B7C (   288):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54B8C (   304):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54B9C (   320):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54BAC (   336):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54BBC (   352):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54BCC (   368):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54BDC (   384):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54BEC (   400):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54BFC (   416):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54C0C (   432):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54C1C (   448):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54C2C (   464):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54C3C (   480):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54C4C (   496):  4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f  OOOOOOOOOOOOOOOO22D54C5C (   512):  4f4f4f4f 4f4f4f4f 02020808           OOOOOOOO....Row-Offset table for variable-length columns:        [<varcol number>, <offset from start of the row>, <varcol length>]        [1, 8, 512]Offset 3176 - row ID=6 row length=524 # varlen cols=122D54C68 (     0):  01066403 00000c02 49494949 49494949  ..d.....IIIIIIII22D54C78 (    16):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54C88 (    32):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54C98 (    48):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54CA8 (    64):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54CB8 (    80):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54CC8 (    96):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54CD8 (   112):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54CE8 (   128):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54CF8 (   144):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54D08 (   160):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54D18 (   176):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54D28 (   192):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54D38 (   208):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54D48 (   224):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54D58 (   240):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54D68 (   256):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54D78 (   272):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54D88 (   288):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54D98 (   304):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54DA8 (   320):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54DB8 (   336):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54DC8 (   352):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54DD8 (   368):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54DE8 (   384):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54DF8 (   400):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54E08 (   416):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54E18 (   432):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54E28 (   448):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54E38 (   464):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54E48 (   480):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54E58 (   496):  49494949 49494949 49494949 49494949  IIIIIIIIIIIIIIII22D54E68 (   512):  49494949 49494949 02020808           IIIIIIII....Row-Offset table for variable-length columns:        [<varcol number>, <offset from start of the row>, <varcol length>]        [1, 8, 512]OFFSET TABLE:Row - Offset 6 (0x06) - 3176 (0x0c68),    5 (0x05) - 2652 (0x0a5c), 4 (0x04) - 2128 (0x0850),    3 (0x03) - 1604 (0x0644), 2 (0x02) - 1080 (0x0438),    1 (0x01) -  556 (0x022c), 0 (0x00) -   32 (0x0020),

这一页，总共有7行数据。00000c02应该是行长度: 524. (020c), 头4个字节，以rowid=0x03为例， 01036103，似乎是第2个字节描述的是rowid. 余下的6103，变成小端0361->dec , 变成865. 经过查询，col2值确实为EEEE(512bytes长)。那么首字节01，到底表示什么呢？