ComputeLocalOnly (Property Keyword)
Controls whether a SqlComputed field is computed only on the local server for federated and shareded tables.
Details
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.
Default
The default is 0.
