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 18.104.22.168 oracle database. I get result if I query it on 22.214.171.124.
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.