Plan hash value: 4171239195
-----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 22542 | 6141K| 4363 (1)| 00:00:53 |
|* 1 | TABLE ACCESS FULL| HOTTILE | 22542 | 6141K| 4363 (1)| 00:00:53 |
-----------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("LEFTBOTTOMLAT"<31.579059250426 AND
"LEFTBOTTOMLNG"<120.29799771321257 AND "RIGHTTOPLNG">120.29238653195342
AND "RIGHTTOPLAT">31.5754159881299)
为什么索引没用到?????????
-----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 22542 | 6141K| 4363 (1)| 00:00:53 |
|* 1 | TABLE ACCESS FULL| HOTTILE | 22542 | 6141K| 4363 (1)| 00:00:53 |
-----------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("LEFTBOTTOMLAT"<31.579059250426 AND
"LEFTBOTTOMLNG"<120.29799771321257 AND "RIGHTTOPLNG">120.29238653195342
AND "RIGHTTOPLAT">31.5754159881299)
为什么索引没用到?????????
解决方案 »
- oracle 11g 的有关问题 (有点繁琐 希望各位大侠帮忙 多给分)
- .sh中如何取得sqlplus的返回值
- 最近安装oracle,不知道为什么老是出问题。因为我要远程连接一个服务器,所以需要用到 net configuration assistant,但是我点击添加服
- PL/SQL记录表如何使用
- 用PL/SQL怎么生成ORCALE脚本
- 多行变多列问题,(并非多行变一列,稍微有点不同)求高手,急。
- 帮个忙,拼个SQL,谢谢,50分一定给
- TOAD连接oracle 总掉线?
- 求一条sql语句
- 视图的数据导入到表中,怎样最方便快捷?
- 删除归档日志问题
- oracle指定job号建立job,job号不对
select id,hotTileName
from HotTile
where leftBottomLat<31.579059250426
and leftBottomLng<120.29799771321257
and rightTopLat>31.5754159881299
and rightTopLng>120.29238653195342
可能oracle觉得不用索引快