unique index和non-unique index的区别

今天在看concept时，看到这样一句话：
For a unique index, one rowid exists for each data value. For a nonunique index, the
rowid is included in the key in sorted order, so nonunique indexes are sorted by the
index key and rowid.

创建了一个unique index和一个non-unique index，然后dump，其中unique index的如下：

Leaf block dump
===============
header address 181911140=0xad7be64
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 1
kdxcosdc 0
kdxconro 520
kdxcofbo 1076=0x434
kdxcofeo 1896=0x768
kdxcoavs 820
kdxlespl 0
kdxlende 0
kdxlenxt 37749902=0x240048e
kdxleprv 0=0x0
kdxledsz 6
kdxlebksz 8032
row#0[8021] flag: -----, lock: 0, data6):  02 40 00 27 00 00
col 0; len 2; (2):  c1 02
row#1[8010] flag: -----, lock: 0, data6):  02 40 00 27 00 01
col 0; len 2; (2):  c1 03
row#2[7999] flag: -----, lock: 0, data6):  02 40 00 27 00 02
col 0; len 2; (2):  c1 04
row#3[7988] flag: -----, lock: 0, data6):  02 40 00 27 00 03
col 0; len 2; (2):  c1 05
row#4[7977] flag: -----, lock: 0, data6):  02 40 00 27 00 04
col 0; len 2; (2):  c1 06
row#5[7966] flag: -----, lock: 0, data6):  02 40 00 27 00 05
col 0; len 2; (2):  c1 07
row#6[7955] flag: -----, lock: 0, data6):  02 40 00 27 00 06
col 0; len 2; (2):  c1 08

non-unique index的dump文件如下：

Leaf block dump
===============
header address 181911140=0xad7be64
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 485
kdxcofbo 1006=0x3ee
kdxcofeo 1830=0x726
kdxcoavs 824
kdxlespl 0
kdxlende 0
kdxlenxt 37750670=0x240078e
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8032
row#0[8020] flag: -----, lock: 0
col 0; len 2; (2):  c1 02
col 1; len 6; (6):  02 40 00 2f 00 00
row#1[8008] flag: -----, lock: 0
col 0; len 2; (2):  c1 03
col 1; len 6; (6):  02 40 00 2f 00 01
row#2[7996] flag: -----, lock: 0
col 0; len 2; (2):  c1 04
col 1; len 6; (6):  02 40 00 2f 00 02
row#3[7984] flag: -----, lock: 0
col 0; len 2; (2):  c1 05
col 1; len 6; (6):  02 40 00 2f 00 03
row#4[7972] flag: -----, lock: 0
col 0; len 2; (2):  c1 06


这两个dump文件看不太懂，只能看到non-unique index的比unique index的多存储了一个rowid，另外在unique index里多了个 data6):  02 40 00 27 00 00那么unique index的每个key对应的rowid是存放在什么位置呢？这个 data6):  02 40 00 27 00 00到底代表什么含义呢？
本人刚接触oracle不久，往各位前辈指点迷津！多谢了

[ 本帖最后由 lsq_008 于 2008-9-5 10:14 编辑 ]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10972173/viewspace-506293/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10972173/viewspace-506293/