Re: [Geotools-devel] SQLServer 2008 indexing support

2009-06-24 Thread Justin Deoliveira
Kevin Neufeld wrote: > Justin Deoliveira wrote: >> Yup, that is the basic approach. In your subclass you need to also >> declare that it can handle spatial filters. See OracleFilterToSQL for >> an example of this. You also need to extend the >> visitBinarySpatialOperator() method to actual do th

Re: [Geotools-devel] SQLServer 2008 indexing support

2009-06-22 Thread Justin Deoliveira
Hi Kevin, Kevin Neufeld wrote: > Hi all, > > I'm trying to add basic indexing support for the SQLServer jdbc project. > > Currently queries that hit the database always perform full table scans and > are of the form: > > SELECT "ID",CAST("geom".STSrid as VARCHAR) + ':' + "geom".STAsText() as "

[Geotools-devel] SQLServer 2008 indexing support

2009-06-19 Thread Kevin Neufeld
Hi all, I'm trying to add basic indexing support for the SQLServer jdbc project. Currently queries that hit the database always perform full table scans and are of the form: SELECT "ID",CAST("geom".STSrid as VARCHAR) + ':' + "geom".STAsText() as "geom" FROM "Roads" It obviously needs a WHERE f