Query SDO_RELATE Spatial Function Is Slow
(Doc ID 1913111.1)
Last updated on JUNE 21, 2022
Applies to:Oracle Spatial and Graph - Version 22.214.171.124 to 126.96.36.199 [Release 11.2 to 12.1]
Information in this document applies to any platform.
Queries with sdo_relate function are very slow in production environment taking more than 30 minutes. There are around 9 million records.
select /*+ ordered */ a.id from spatial_1 b, spatial_1 a where a.id=28289488 and b.id=24865690 and sdo_relate(a.shape,b.shape, 'mask=covers+contains') ='TRUE';
no rows selected
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document