.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 '{}'