2,596
社区成员
发帖
与我相关
我的任务
分享sybase Error625
今天在数据库中执行查询
SELECT * from B_MC
WHERE MC LIKE "%履行%"
报一下错误：
Index id 2 on table id 32000114 cannot be used in the optimization of a query as it is SUSPECT. Please have the SA run DBCC REINDEX on the specified table.随后按照提示执行：DBCC REINDEX(B_MC)
又报错：
Checking B_MC: Logical pagesize is 4096 bytes
Error (625) Adaptive Server failed to retrieve a row via its RID in database 'K_DM' because the entry in the offset table for that RID is less than or equal to 0. Rid pageid = 0x261; row num = 0x6e. Page pointer = 0x30F95000, pageno = 609, status = 0x11, objectid = 32000114, indexid = 0, level = 0.REINDEX received an exception - command aborted.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
之后在查看sybase官网中关于625的错误，地址如下：http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc00729_1500/html/errMessageAdvRes/BACCGFID.htm
按照文中所讲 分别执行
set showplan on
GO
set noexec on
go
SELECT * from B_MC
WHERE MC LIKE "%履行%"
这部分执行后显示：
STEP 1
The type of query is SELECT.
FROM TABLE
B_MC
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 4 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
并没有官网文中所讲的INDEX项，到了这里不知道怎么解决问题 ，help
SELECT * from B_MC
WHERE MC LIKE "%履行%"
报一下错误：
Index id 2 on table id 32000114 cannot be used in the optimization of a query as it is SUSPECT. Please have the SA run DBCC REINDEX on the specified table.随后按照提示执行：DBCC REINDEX(B_MC)
又报错：
Checking B_MC: Logical pagesize is 4096 bytes
Error (625) Adaptive Server failed to retrieve a row via its RID in database 'K_DM' because the entry in the offset table for that RID is less than or equal to 0. Rid pageid = 0x261; row num = 0x6e. Page pointer = 0x30F95000, pageno = 609, status = 0x11, objectid = 32000114, indexid = 0, level = 0.REINDEX received an exception - command aborted.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
之后在查看sybase官网中关于625的错误，地址如下：http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc00729_1500/html/errMessageAdvRes/BACCGFID.htm
按照文中所讲 分别执行
set showplan on
GO
set noexec on
go
SELECT * from B_MC
WHERE MC LIKE "%履行%"
这部分执行后显示：
STEP 1
The type of query is SELECT.
FROM TABLE
B_MC
Nested iteration.
Table Scan.
Forward scan.
Positioning at start of table.
Using I/O Size 4 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
并没有官网文中所讲的INDEX项，到了这里不知道怎么解决问题 ，help
...全文
请发表友善的回复…
发表回复
zhenzhenzhe 2013-10-25
- 打赏
- 举报
最后我重建了此表 有导入之前的数据 在查询就没之前的问题了
