[Mapserver-users] Mapserver - OGR - Oracle (revisited)

[bartvde at xs4all.nl]

Hi list,

on a previous post I mentioned that it appeared that the BBOX of the WMS
request was not used in the query sent to Oracle.

This was caused by the DATA statement in the MAP file. If we used a select
statement there (like the one commented out in the example below), always
a full table scan was performed. Using the lower "syntax" it works fine.

#   DATA "select ORA_GEOMETRY from AdreSDO"
    DATA AdreSDO

But now there is the following problem that a WMS GetCapabilities request
takes more than one minute (also resulting in a full table scan in
Oracle). Is there any way to prevent this, can it be read from the
USER_SDO_GEOM_METADATA table or the MAP file?

Thanks in advance for any info.

Best regards,
Bart