| Parameter | Type | Description | Example |
|---|---|---|---|
| object | Materialized view recommendation details. | ||
| BaseTables | array | The base table associated with the subquery. | |
| open_struct_MvBaseTableDetailModel | The details of the base table. | ||
| AcceleratedQueriesCount | long | The number of accelerated queries. | 32 |
| SupportIncrementalRefresh | boolean | Whether the current subquery supports incremental refresh. | true |
| SubqueryId | long | The ID of the subquery. | 1 |
| SavedScanbytes | long | Estimated bytes scanned reduction by current materialized view from correlated parent queries (posterior calculation). | 321321223 |
| Subquery | string | The extracted public subquery. | SELECT * FROM demo.tbl |