Slide 42
Slide 42 text
利⽤イメージ (SDO_FILTER演算⼦でインメモリ・スキャン)
• 問合せウィンドウ(左下の座標が(4,6)、右上の座標が(8,8)の矩形)と相互作⽤するジオメトリを選択する
インメモリのSpatialサポート
Copyright © 2021, Oracle and/or its affiliates.
47
SQL> SELECT c.mkt_id, c.name FROM cola_markets c
2 WHERE SDO_FILTER(c.shape, SDO_GEOMETRY(2003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1,1003,3), SDO_ORDINATE_ARRAY(4,6, 8,8))) = 'TRUE’;
-----------------------------------------------------------
| Id | Operation | Name | Rows |
-----------------------------------------------------------
| 0 | SELECT STATEMENT | | 200 |
|* 1 | TABLE ACCESS INMEMORY FULL| COLA_MARKETS | 200 |
-----------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("C"."SYS_IME_SDO_6D2C60D2D8644FA8BF3D4E22D76C48E7">=SDO_GEOM_MIN_X("M
DSYS"."SDO_GEOMETRY"(2003,NULL,NULL,"SDO_ELEM_INFO_ARRAY"(1,1003,3),"SDO_ORDINATE_A
RRAY"(4,6,8,8)))-5.0000000050000005E-003D AND
"C"."SYS_IME_SDO_D05103A9F2124F55BF9C3C15A4512E87"<=SDO_GEOM_MAX_X("MDSYS"."SDO_GEO
METRY"(2003,NULL,NULL,"SDO_ELEM_INFO_ARRAY"(1,1003,3),"SDO_ORDINATE_ARRAY"(4,6,8,8)
))+5.0000000050000005E-003D AND "C"."SYS_IME_SDO_B996119FE7284F98BFFB307399EF6AE0">
=SDO_GEOM_MIN_Y("MDSYS"."SDO_GEOMETRY"(2003,NULL,NULL,"SDO_ELEM_INFO_ARRAY"(1,1003,
3),"SDO_ORDINATE_ARRAY"(4,6,8,8)))-5.0000000050000005E-003D AND
"C"."SYS_IME_SDO_BF1884A56A084FF9BF49D38285AD73A3"<=SDO_GEOM_MAX_Y("MDSYS"."SDO_GEO
METRY"(2003,NULL,NULL,"SDO_ELEM_INFO_ARRAY"(1,1003,3),"SDO_ORDINATE_ARRAY"(4,6,8,8)
))+5.0000000050000005E-003D)