那你select *from sapr3.tstct wgere ttext like 'SAPcomm:%'呢?
你看我的:
SQL> select * from sapr3.tstct where tcode='SCOM';
S TCODE
TTEXT
- -------------------- ------------------------------------
D SCOM
SAPcomm: konfiguration
E SCOM
SAPcomm: Configuration
1 SCOM
SAP命令: 配置颗息
SQL> select * from sapr3.tstct where ttext like 'SAPcomm:%';
S TCODE
TTEXT
- -------------------- ------------------------------------
D SCOM
SAPcomm: konfiguration
D SKRT
SAPcomm: Routing-Test
E SCOM
SAPcomm: Configuration
E SKRT
SAPcomm: Routing test
1 SKRT
SAPcomm: 路由测试
那你select *from sapr3.tstct wgere ttext like 'SAPcomm:%'呢?
你看我的:
SQL> select * from sapr3.tstct where tcode='SCOM';
S TCODE
TTEXT
- -------------------- ------------------------------------
D SCOM
SAPcomm: konfiguration
E SCOM
SAPcomm: Configuration
1 SCOM
SAP命令: 配置颗息
SQL> select * from sapr3.tstct where ttext like 'SAPcomm:%';
S TCODE
TTEXT
- -------------------- ------------------------------------
D SCOM
SAPcomm: konfiguration
D SKRT
SAPcomm: Routing-Test
E SCOM
SAPcomm: Configuration
E SKRT
SAPcomm: Routing test
1 SKRT
SAPcomm: 路由测试
我估计是记录太多了,呢找不到了。
One of possible reason is that some indexes in your table sapr3.tstct are corrupted; you may drop all sapr3.tstct indexes and rebuild it to check the result again.Some time no criteria where may use Index Full scan to retrieve records, if that index is corrupted, miss records problem may happen.
One of possible reason is that some indexes in your table sapr3.tstct are corrupted; you may drop all sapr3.tstct indexes and rebuild it to check the result again.Some time no criteria where may use Index Full scan to retrieve records, if that index is corrupted, missing records problem may happen.