नोट
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप साइन इन करने या निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
Applies to: 
Databricks SQL Databricks Runtime 18.1 and above
The ANALYZE TABLE … DROP STATISTICS command removes optimizer statistics from a Unity Catalog table. Use this command to clear stale or incorrect statistics so the query optimizer no longer relies on them. To collect new statistics, see ANALYZE TABLE … COMPUTE STATISTICS.
Syntax
ANALYZE TABLE table_name DROP [ MANUAL | AUTO | ALL ] STATISTICS
Parameters
-
Identifies the table whose statistics you want to drop. The name must not include a temporal specification or options specification or path. If the table cannot be found Azure Databricks raises a TABLE_OR_VIEW_NOT_FOUND error condition.
{ MANUAL | AUTO | ALL }An optional qualifier that selects which statistics to drop. If you omit the qualifier, the command drops only manual statistics.
Qualifier Description MANUALThe default. Drops statistics collected by ANALYZE TABLE … COMPUTE STATISTICS. AUTODrops statistics collected by auto-stats and Predictive optimization for Unity Catalog managed tables. ALLDrops both manual and automatic statistics.
Requirements
- The table must be registered in Unity Catalog. Running this command against a Hive metastore table raises an
AnalysisException. - You must have
MODIFYprivilege on the table.
Examples
-- Drop only manual statistics. This is the default behavior.
> ANALYZE TABLE main.sales.orders DROP STATISTICS;
-- Drop only statistics collected by auto-stats or predictive optimization.
> ANALYZE TABLE main.sales.orders DROP AUTO STATISTICS;
-- Drop all statistics for the table.
> ANALYZE TABLE main.sales.orders DROP ALL STATISTICS;