看得懂执行计划的进来
xkx12 2012-03-19 12:44:00 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)
为什么索引没用到?????????