Data B-tree leaf
K {1}
V {\17\00\00\00\10_id\00\01\00\00\00\10ran\00\05\00\00\00\00}
K {2}
V {\17\00\00\00\10_id\00\02\00\00\00\10ran\00\0a\00\00\00\00}
K {3}
V {\17\00\00\00\10_id\00\03\00\00\00\10ran\00\0a\00\00\00\00}
K {4}
V {\17\00\00\00\10_id\00\04\00\00\00\10ran\00\05\00\00\00\00}
K {5}
V {\17\00\00\00\10_id\00\05\00\00\00\10ran\00\05\00\00\00\00}
Index B-tree leaf
K {+\02\04}
V {\00\08}
K {+\04\04}
V {\00\10}
K {+\06\04}
V {\00\18}
K {+\08\04}
V {\00 }
K {+\0a\04}
V {\00(}
Secondary index B-tree leaf
K {+\0a\04\00\08}
V {}
K {+\0a\04\00 }
V {}
K {+\0a\04\00(}
V {}
K {+\14\04\00\10}
V {}
K {+\14\04\00\18}
V {}
As you can see i see some mapping from the primary index B-tree to the secondary index. However,