Oracle spatial performance issue

[Pål Kristensen]

Hi!

I have set up a mapfile with layers that uses oracle spatial data. The
problem is that the performance is rather bad. This is how I have set up the
connection in the LAYER object.

   LAYER
      NAME "N50Hoydekurver"
      STATUS ON
      CONNECTION "user/pass at KARTINNS_SKRIVDB06"
      CONNECTIONTYPE oraclespatial
      DATA "SHAPE FROM KARTDATA.N50_HoydeKontur USING UNIQUE OBJECTID
VERSION 10g"

When this layer is queried the resulting SQL that is submitted to the
database typically looks like this:

SELECT OBJECTID, OBJTYPE, SHAPE FROM KARTDATA.N50_HoydeKontur 
WHERE SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-26711.6293,6726071.91,-14068.0091,6736415.72)
),'querytype=window') = 'TRUE'

By adding the keyword /*+ ordered */ to the select statement considerably
speeds up the quary. The resulting SQL statement the looks like this:

SELECT /*+ ordered */OBJECTID, OBJTYPE, SHAPE FROM KARTDATA.N50_HoydeKontur 
WHERE SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-26711.6293,6726071.91,-14068.0091,6736415.72)
),'querytype=window') = 'TRUE'

This test is performed manually because I haven't find anywhere to insert
the keyword in the mapfile. Anyone have any ideas on how I could accomplish
to tell MapServer to insert the keyword before sending the SQL to the
database?

regards,
Pål Kristensen
-- 
View this message in context: http://www.nabble.com/Oracle-spatial-performance-issue-tf4941783.html#a14146626
Sent from the Mapserver - User mailing list archive at Nabble.com.