On 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-ver15
if 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-ver15
they'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
HTH, Mark
_______________________________________________
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
