Is It Allowed To Have A Polygon As A Query Window?
(Doc ID 1542319.1)
Last updated on JANUARY 16, 2020
Applies to:
Oracle Spatial and Graph - Version 11.2.0.3 and laterInformation in this document applies to any platform.
Goal
Question:
Is it allowed to use a polygon instead of an optimized rectangle?
For example the following query uses an optimized rectangle:
select count(1) from gps.current_ilm_location
where serial_no='AD009999'
and sdo_relate(spatial_point,SDO_GEOMETRY(
2003,
8307,
NULL,
SDO_ELEM_INFO_ARRAY(1,1003,3),
SDO_ORDINATE_ARRAY(-93.410661,44.465527,-92.595369,44.990445 )
), 'mask=anyinteract querytype=window') = 'TRUE';
COUNT(1)
----------
1
Is it possible to use a polygon like this?
select count(1) from gps.current_ilm_location
where serial_no='AD009999'
and sdo_relate(spatial_point,SDO_GEOMETRY(
2003,
8307,
NULL,
SDO_ELEM_INFO_ARRAY(1,1003,1),
SDO_ORDINATE_ARRAY(
-93.410661,44.465527,
-92.595369,44.465527,
-92.595369,44.990445,
-93.410661,44.990445,
-93.410661,44.465527)
), 'mask=anyinteract querytype=window') = 'TRUE';
COUNT(1)
----------
1
Solution
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
Goal |
Solution |