One of the easiest ways is to just introduce a small syntax error in your data statement (change the tablename or something). Then Mapserver will print the spatial sql statement to the screen (using the cgi version)
Mike Smith -- Michael Smith RSGIS Center ERDC - CRREL US Army Corps of Engineers On 12/8/06 11:31 AM, "Sebastian Schmitz" <[EMAIL PROTECTED]> wrote: > Hi, > > We want to evaluate the best approach for tuning MapServer on a large > table (300.000 rows) in Oracle Spatial. Current idea is to create a > partitioned table with each partition having its spatial index. I would > like to know, how CONNECTIONTYPE oraclespatial handles the extent to > draw when retrieving data from Oracle Spatial. For this, it would help > to see the SQL Mapserver generates and uses when accessing Oracle > Spatial using CONNECTIONTYPE oraclespatial. How can I do this? > > > Any hints greatly appreciated. > > Cheers > > Sebastian > >
