Is It Allowed To Have A Polygon As A Query Window? (Doc ID 1542319.1)

Last updated on JANUARY 16, 2020

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.