sp_drop_openrowset_statistics (Transact-SQL)
Applies to:
Azure SQL Managed Instance
Azure Synapse Analytics (serverless SQL pool only)
Drops column statistics for a column in the OPENROWSET
path of Azure Synapse serverless SQL pools. For more information, see Statistics in Synapse SQL. This procedure is also used by Azure SQL Managed Instance for column statistics in external data sources via OPENROWSET
.
There's no direct method to update existing statistics. Instead, drop and create statistics using sp_create_openrowset_statistics.
Transact-SQL syntax conventions
Syntax
sys.sp_drop_openrowset_statistics
[ @stmt = ] N'stmt'
Arguments
[ @stmt = ] N'stmt'
Specifies a Transact-SQL statement that returns column values to be used for statistics. You can use TABLESAMPLE
within @stmt to specify samples of data to be used. If TABLESAMPLE
isn't specified, FULLSCAN
is used.
<tablesample_clause> ::= TABLESAMPLE ( sample_number PERCENT )
Remarks
Statistics metadata isn't available for OPENROWSET
columns.
Permissions
Requires ADMINISTER BULK OPERATIONS
or ADMINISTER DATABASE BULK OPERATIONS
permissions.
Examples
For usage scenarios and examples, review Update statistics.
Related content
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho