The leaf-level pages store the index keys and page pointers, plus a pointer to the row offsettable on the data page.
并且聚集索引中数据页就是页级别索引页,综合上述两点,聚集索引占据空间更小。
2
Here, memory indirect addressing mode (line 33) is used to access the command table along with an offset in ESI (and EDI) and a multiplier.
这里使用内存间接寻址模式(第31行)访问命令表,还使用了ESI(和EDI)中的偏移量和一个乘数。
3
The RAWDEVSIZE program analyzes available raw devices and stores the offset, size, and path information of free blocks into a database table named free_chunks.