OracleSpatial attribute queries

[Fernando Simon]

Hi Johan,
It's relate with the way how Mapserver do the query. It's need to work
with many kind of sources, and sometimes cannot be the better way for
databases.
For Oracle you can define a token in you data definition to force the
Mapserver Oracle driver to don't the extents (bbox) in the query. You
just need to define the NONE in your data, as example:
data "geom from table USING NONE"
You can see more about this in this page:
http://mapserver.gis.umn.edu/docs/howto/oracle_spatial_howto
So, you can change the data parameter before apply the query and test
the results.
Best regards.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------


Hallgren Johan E wrote:
>
> This is an old question but still the problem remains.
>
> I use MapServer/MapScript/csharp.
>
> I use the OracleSpatial built in support in MapServer.
>
> I want to show a selected bunch of features on the map. The selection
> is made only by an attribute query (postcode = 123).
>
> By turning logging on I can se that even if I do an attribute query
> the query sent to Oracle include both the envelope and the actual query.
>
> I can catch that query and run it in SQLPlus and I will see it takes
> looonnngg time to perform. If I remove the envelope it’s much faster.
> I have created index on both the geometry and the attribute column,
> but as I can understand it’s not possible to create index on shape and
> the attribute column in combination.
>
> So my question is: why must the geometry be part of the query when I
> don’t need it?
>
> /Johan
>
>
>       *___________________________________*
>
>
>       *Johan Hallgren*
>
> WM-data
>
> Pelle Bergs backe 3
>
> Box 1938, 791 19 Falun
>
> Tel (och mobil): 023-547 46 (int: +46-2354746)
>
> _johan.e.hallgren_ at wmdata.com
> <BLOCKED::mailto:johan.e.hallgren at wmdata.com>
>
> http://www.wmdata.se
> <BLOCKED::/exchweb/bin/redir.asp?URL=http://www.wmdata.se/>
>