gpt4 book ai didi

sql-server-2008 - SQL Server 2008 : What is lazy schema validation?

转载 作者:行者123 更新时间:2023-12-04 20:22:53 27 4
gpt4 key购买 nike

当我制作链接服务器时看到这个选项

最佳答案

基本上,它只是让您通过不为每个请求请求元数据来提高远程表的性能,仅当实际需要表中的数据时。
Lazy Schema Validation:

If this option is set to false, thedefault value, SQL Server checks forschema changes that have occurredsince compilation in remote tables.This check occurs before queryexecution. If there is a change in theschema, SQL Server recompiles thequery with the new schema.

If this option is set to true, schemachecking of remote tables is delayeduntil execution. This can cause adistributed query to fail with anerror if the schema of a remote tablehas changed between query compilationand execution.


http://msdn.microsoft.com/en-us/library/ms190918.aspx

关于sql-server-2008 - SQL Server 2008 : What is lazy schema validation?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/4455116/

27 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com