真是一波未平,一波又起,问题又来了!
SELECT COUNT(1) FROM ENT_WSZZ.ENTITY_LINK WHERE stabh='R1103071129082504560109' AND stbbh='D1103041658171501040645';
stabh和stbbh都建了索引。可是好像有时stabh用不了,下面是执行计划
| Id | Operation | Name | Rows | Bytes
|Cost (%CPU)| Time | Pstart| Pstop |
--------------------------------------------------------------------------------
-----------------------------------------
| 0 | SELECT STATEMENT | | 1 | 49
| 6 (0)| 00:00:01 | | |
| 1 | SORT AGGREGATE | | 1 | 49
| | | | |
|* 2 | TABLE ACCESS BY GLOBAL INDEX ROWID| ENTITY_LINK | 1 | 49
| 6 (0)| 00:00:01 | ROWID | ROWID |
|* 3 | INDEX RANGE SCAN | ENTITY_LINK_STBBH | 3 |
| 4 (0)| 00:00:01 | | |