你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站,请访问 https://docs.azure.cn。
.alter materialized-view policy caching command
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer
Changes the materialized view's cache policy. To speed up queries, data is cached on processing nodes, SSD, or even in RAM. The cache policy allows your database to describe the data artifacts that it uses, so that more important data can take priority.
Permissions
You must have at least Table Admin permissions to run this command.
Syntax
.alter
materialized-view
MaterializedViewName policy
caching
PolicyParameters
Learn more about syntax conventions.
Parameters
Name | Type | Required | Description |
---|---|---|---|
MaterializedViewName | string |
✔️ | The name of the materialized view. |
PolicyParameters | string |
✔️ | One or more policy parameters. For parameters, see cache policy. |
Examples
Set the caching policy to include the last 30 days.
.alter materialized-view MyMaterializedView policy caching hot = 30d
Set the caching policy to include the last 30 days and data from January and April 2021.
.alter materialized-view MyMaterializedView policy caching
hot = 30d,
hot_window = datetime(2021-01-01) .. datetime(2021-02-01),
hot_window = datetime(2021-04-01) .. datetime(2021-05-01)