Skip to main content

ComputeLocalOnly (Property Keyword)

Controls whether a SqlComputed field is computed only on the local server for federated and shareded tables.


When the value is 1, the SqlComputeCode is only executed only on the server where the data exists. As a result, in a sharded or federated environment, computed data is only returned from the system that the query was issued from. The SqlComputeCode is not computed on the other shards.

When the value is 0, the SqlComputeCode can be executed on any server.


The default is 0.

See Also

FeedbackOpens in a new tab