One of the most important tasks of a GIS application is the "Spatial Join" or "das Verschneiden" (in German):
Oracle Maps may fully take advantage of the inbuilt Oracle Spatial Technology as part of the database. The functions ANYINTERACT and/or SDO_RELATE are used to calculate above e.g. which FOI (customer) is located in the Polygon (REGIERUNGSBEZIRK = County).
When you click ('mouse_click') on the polygon the Spatial Function is invoked and no timeconsuming calculations are carried out - and you have the result within a second.
"How To?" --> in my "Oracle-Maps-Tipps" BLOG