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 | | |
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 | | |
stabh='R1103071129082504560109' AND stbbh='D1103041658171501040645';