Spatial and native dynamic compilation

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Mon, 10 Jun 2013 17:55:42 -0700 (PDT)
Message-ID: <12bf5da0-fee0-44d9-8a65-0a481f29d80f_at_googlegroups.com>

We have 10.2.0.4 database used for Spatial. It runs on AIX LPAR. Most SQL statements look like this:

SELECT FROM TABLE WHERE SDO_RELATE(B.GEOLOC, SDO_GEOMETRY(value1, value2, SDO_POINT_TYPE(:XCoord, :YCoord, NULL),NULL,NULL), 'MASK=CONTAINS+COVERS') = 'TRUE'

Plan shows access based on DOMAIN INDEX. We are looking at allocating more CPU to this LPAR but this will require buying Spatial licenses. Question: would it help to use native dynamic compilation for Spatial objects (those owned by MDSYS)? Anyone has real-life experience?

The difficulty is that this is 10.2, not 11, so we will need external C compiler. Received on Tue Jun 11 2013 - 02:55:42 CEST