设为首页 加入收藏

TOP

堆表的在执行Select语句时的默认排序问题――分析问题(二)
2014-11-24 02:49:32 来源: 作者: 【 】 浏览:3
Tags:执行 Select 语句 时的 默认 排序 问题 分析
0x41a
-------------------
DELIVERY_NO = BE404942550162
www.2cto.com
Slot 4 Offset 0x1ac6
--------------------
DELIVERY_NO = BE404942550169
Slot 5 Offset 0x19a4
--------------------
DELIVERY_NO = BE404942550170
Slot 6 Offset 0x1882
--------------------
DELIVERY_NO = BE404942550171
Slot 7 Offset 0x1760
--------------------
DELIVERY_NO = BE404942550172
Slot 8 Offset 0x163e
--------------------
DELIVERY_NO = BE404942550173
Slot 9 Offset 0x151c
--------------------
DELIVERY_NO = BE404942550174
Slot 10 Offset 0x13fa
---------------------
DELIVERY_NO = BE404942550175
Slot 11 Offset 0x12d8
---------------------
DELIVERY_NO = BE404942550176
Slot 12 Offset 0x11b6
---------------------
DELIVERY_NO = BE404942550177
Slot 13 Offset 0x1094
---------------------
DELIVERY_NO = BE404942550178
Slot 14 Offset 0xf72
--------------------
DELIVERY_NO = BE404942550163
Slot 15 Offset 0xe50
--------------------
DELIVERY_NO = BE404942550164
Slot 18 Offset 0xd2e
--------------------
DELIVERY_NO = BE404942550167
Slot 19 Offset 0xc0c www.2cto.com
--------------------
DELIVERY_NO = BE404942550168
-----------------------------------------------------第二页---------------------------------
PAGE: (1:3200)
--------------
BUFFER:
-------
BUF @0x016AAC00
---------------
bpage = 0x1B250000 bhash = 0x00000000 bpageno = (1:3200)
bdbid = 8 breferences = 1 bstat = 0x9
bspin = 0 bnext = 0x00000000
PAGE HEADER:
------------
Page @0x1B250000
----------------
m_pageId = (1:3200) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x8000
m_objId = 1285579618 m_indexId = 0 m_prevPage = (0:0)
m_nextPage = (0:0) pminlen = 69 m_slotCnt = 2
m_freeCnt = 7512 m_freeData = 676 m_reservedCnt = 0
m_lsn = (939:344:3) m_xactReserved = 0 m_xdesId = (0:0)
m_ghostRecCnt = 0 m_tornBits = 12289
Allocation Status
-----------------
GAM (1:2) = NOT ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:1) = 0x1 50_PCT_FULL DIFF (1:6) = CHANGED
ML (1:7) = NOT MIN_LOGGED www.2cto.com
Slot 0 Offset 0x60
------------------
DELIVERY_NO = BE404942550166
Slot 1 Offset 0x182
-------------------
DELIVERY_NO = BE404942550165
从上面的数据页中的结构来看,每一页相对应的Slot所记录的数据与在数据库中查询出来的顺序一样。
作者 DotNet菜园
首页 上一页 1 2 下一页 尾页 2/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇SQL语句执行效率瓶颈 下一篇查询sql语句的执行计划

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·Shell 基本运算符 - (2025-12-24 09:52:56)
·Shell 函数 | 菜鸟教 (2025-12-24 09:52:54)
·Linux 常用命令集合 (2025-12-24 09:52:51)
·socket 编程如何实现 (2025-12-24 09:20:41)
·Python创建简易的Soc (2025-12-24 09:20:39)