|
数据库版本9204,有一张数据表,查询空间字段(sdo_geometry)速度非常的慢,而查询非空间字段速度就很快,空间字段上已经加了空间索引,对表也收集了统计数据,似乎都没什么效果,有哪位大侠能帮忙优化一下,谢谢!!!
查询空间字段:
SQL> select gwm_geometry from s_grid_p_market where districtid = 1200;
已选择4166行。
已用时间: 00: 09: 26.46
执行计划
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=311 Card=3875 Bytes=
825375)
1 0 TABLE ACCESS (FULL) OF 'S_GRID_P_MARKET' (Cost=311 Card=38
75 Bytes=825375)
统计信息
----------------------------------------------------------
6 recursive calls
0 db block gets
6293 consistent gets
0 physical reads
0 redo size
8595000 bytes sent via SQL*Net to client
3766 bytes received via SQL*Net from client
307 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
4166 rows processed
查询非空间字段:
SQL> select gwm_fid from s_grid_p_market where districtid = 1200;
已选择4166行。
已用时间: 00: 00: 00.46
执行计划
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=311 Card=3875 Bytes=
38750)
1 0 TABLE ACCESS (FULL) OF 'S_GRID_P_MARKET' (Cost=311 Card=38
75 Bytes=38750)
统计信息
----------------------------------------------------------
0 recursive calls
0 db block gets
3478 consistent gets
0 physical reads
0 redo size
47394 bytes sent via SQL*Net to client
2174 bytes received via SQL*Net from client
279 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
4166 rows processed
哪位大侠能帮忙看看有什么办法提高空间数据的查询速度!!!! |
|