On 11/25/20 8:14 PM, mark wrote:
actually, the table hints are added to the query here: https://github.com/geotools/geotools/blob/f3fd3149a7e9c5b1ff12fdb91b7aed5284325073/modules/plugin/jdbc/jdbc-sqlserver/src/main/java/org/geotools/data/sqlserver/SQLServerDialect.java#L901-L947On 11/25/20 11:07 AM, Paul Wittle wrote:Hi,Does anyone know what the Table hints and instance options are for at the bottom of the a SQL Server store creation page?I'm not 100% sure and never used either, but- SQL server can run several instances on the same server, see eg.: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/database-engine-instances-sql-server?view=sql-server-ver15if not specified the default instance is used to make a connection to.- table hints are an advanced form of query optimization: https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table?view=sql-server-ver15they're appended to the select queries: https://github.com/geotools/geotools/blob/f3fd3149a7e9c5b1ff12fdb91b7aed5284325073/modules/plugin/jdbc/jdbc-sqlserver/src/main/java/org/geotools/data/sqlserver/SQLServerDialect.java#L799-L811
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
