.alter database merge policy
Change a database's merge policy. The merge policy defines if and how Extents (Data Shards) in the cluster should get merged.
Syntax
.alter database DatabaseName policy merge PolicyObject
Arguments
- DatabaseName - Specify the name of the database.
- PolicyObject - Define a policy object. For more information, see merge policy.
Examples
Set all properties of the policy explicitly, at the database level:
.alter database [database_name] policy merge ```
{
"RowCountUpperBoundForMerge": 16000000,
"OriginalSizeMBUpperBoundForMerge": 0,
"MaxExtentsToMerge": 100,
"LoopPeriod": "01:00:00",
"MaxRangeInHours": 24,
"AllowRebuild": true,
"AllowMerge": true,
"Lookback": {
"Kind": "Default"
}
}```
Set the default merge policy at database level:
.alter database [database_name] policy merge '{}'