| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Spatial Question
Looks like it is the spatial index.
Try to drop the index and try again without it. If it works you know it is the index.
You should experiment with the index parameters, like this maybe:
drop index GEO_IX;
create index GEO_IX on SMALL(geometry)
indextype is MDSYS.SPATIAL_INDEX PARAMETERS('SDO_LEVEL=6, SDO_NUMTILES=8');
Hans Received on Thu Mar 23 2000 - 08:26:01 CST
 |
 |