unique index的index leaf node里面rowid没有参与排序:
row#0[8025] flag: ------, lock: 0, len=11, data:(6): 01 00 00 84 00 00
col 0; len 2; (2): c1 02
row#1[8014] flag: ------, lock: 0, len=11, data:(6): 01 00 00 84 00 01
col 0; len 2; (2): c1 03
row#2[8003] flag: ------, lock: 0, len=11, data:(6): 01 00 00 84 00 02
col 0; len 2; (2): c1 04
--========================
nonunique index的index leaf node里面rowid参与了排序:
row#0[8025] flag: ------, lock: 0, len=11
col 0; len 1; (1): 61
col 1; len 6; (6): 01 00 00 84 00 00
row#1[8014] flag: ------, lock: 0, len=11
col 0; len 1; (1): 62
col 1; len 6; (6): 01 00 00 84 00 01
row#2[8003] flag: ------, lock: 0, len=11
col 0; len 1; (1): 63
col 1; len 6; (6): 01 00 00 84 00 02
row#0[8025] flag: ------, lock: 0, len=11, data:(6): 01 00 00 84 00 00
col 0; len 2; (2): c1 02
row#1[8014] flag: ------, lock: 0, len=11, data:(6): 01 00 00 84 00 01
col 0; len 2; (2): c1 03
row#2[8003] flag: ------, lock: 0, len=11, data:(6): 01 00 00 84 00 02
col 0; len 2; (2): c1 04
--========================
nonunique index的index leaf node里面rowid参与了排序:
row#0[8025] flag: ------, lock: 0, len=11
col 0; len 1; (1): 61
col 1; len 6; (6): 01 00 00 84 00 00
row#1[8014] flag: ------, lock: 0, len=11
col 0; len 1; (1): 62
col 1; len 6; (6): 01 00 00 84 00 01
row#2[8003] flag: ------, lock: 0, len=11
col 0; len 1; (1): 63
col 1; len 6; (6): 01 00 00 84 00 02
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1425435/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19602/viewspace-1425435/