堆表的在执行Select语句时的默认排序问题——分析问题(4)
来源：未知 责任编辑：责任编辑 发表时间:2015-09-17 09:42 点击:次
---------------------
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
相关新闻>>
最新推荐更多>>>
- 发表评论
-
- 最新评论 更多>>
