On Sat, Dec 1, 2012 at 4:23 PM, Sergeant_york <[email protected]>wrote:
> 6- We have some tables that geoserver cannot use its spatial index because
> of a bug in database server. Mssql 2008 r2 bug happens when there are many
> cores in the machine (128 in our case), so query optimizer cannot
> understand
> spatial index usage will be helpful then tries to use normal index. Is
> there
> a way to force geoserver to use particular indexes in mssql? For example :
> with(index(x index)) command etc.
>
There is no way to force GeoServer to use the index right now.
Some other user said that to force the usage of the index the SQL query
should
be modified to contain an explicit query hint, this kind of modification
would require
a bit of changes in the overall JDBC modules (most the code to access a
spatial
database is shared between all databases, only differences are factored out
in specific classes, and query hint support is not there in the
architecture to start with).
Not a massive undertaking by any means, but something that would require
some
work for sure. Patches welcomed :-)
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
