This content has been marked as final. Show 4 replies
No.. i do not know about the bug.
I have used a simple query
select * from geodata where sdo_relate(shape,geometry,mask='ANYINTERACT')='TRUE'
and i dont get any results in 126.96.36.199 oracle database. I get result if I query it on 188.8.131.52.
Is this the workaround for the bug.
SQL> connect /as sysdba
SQL> alter session set current_schema=MDSYS;
SQL> DISASSOCIATE STATISTICS FROM INDEXTYPES
SQL> DISASSOCIATE STATISTICS FROM PACKAGES sdo_3gl
SQL> DISASSOCIATE STATISTICS FROM PACKAGES prvt_idx
Yes, that is it.
This will force Oracle to always use the index instead of using a FTS (which is normally what you want). However, if you ask for a large percentage of the data, it will then be slower.