DROP STATS
Drops statistics on a blockchain. For examples, see Examples.
Syntax​
DROP STATS|STATISTICS ON
{ blockchain_name | database_name.blockchain_name }
Arguments​
database_name
Is the name of the database in which the target blockchain persists.
blockchain_name
The name of the blockchain whose stats will be dropped.
Permissions​
MANAGEMENT permission required on the target blockchain.
MANAGEMENT permissions default to members of the admin and developer fixed database roles. Members of the admin role can transfer permissions to other users.
Best Practices​
Dropping statistics from a blockchain can increase mutation speed and reduce storage, but consequently may cause the optimizer to return non-optimal query plans, i.e, drop statistics from infrequently accessed blockchains with heavy transaction loads. Please refer to stats overview for a more detailed explanation on how statistics are built for performance.
Limitations​
- Dropping stats from a blockchain without stats will error.
- Currently, once statistics are dropped from a blockchain they can't be rebuilt.
Example​
The following example will drop stats from the pricing blockchain in the demo database,
reducing mutation speed and storage costs for the pricing blockchain.
DROP STATS ON financial.pricing