编辑

通过

你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

Row order policy

  • 项目

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer

The row order policy sets the preferred arrangement of rows within an extent. The policy is optional and set at the table level.

The main purpose of the policy is to improve the performance of queries that are narrowed to a small subset of values in ordered columns. Additionally, it may contribute to improvements in compression.

Use management commands to alter, alter-merge delete, or show the row order policy for a table.

Note

Once the policy is set, it will affect data ingested from that point onward.

When to set the policy

It's appropriate to set the policy under the following conditions:

  • Most queries filter on specific values of a certain large-dimension column, such as an "application ID" or a "tenant ID"
  • The data ingested into the table is unlikely to be preordered according to this column

Performance considerations

There are no hardcoded limits set on the amount of columns, or sort keys, that can be defined as part of the policy. However, every additional column adds some overhead to the ingestion process, and as more columns are added, the effective return diminishes.