/SQL/Oracle calculate statistics on partition

Oracle calculate statistics on partition

ANALYZE TABLE SCHEMA.MY_TABLE PARTITION (PARTITION_NAME) COMPUTE STATISTICS;

exec DBMS_STATS.GATHER_TABLE_STATS('MY_USER', 'MY_TABLE', ESTIMATE_PERCENT=>50, 
	GRANULARITY=>'PARTITION', PARTNAME=>'My_PARTITION_NAME', DEGREE => 8);

Similar codes

0 vote280 views1 answer
Output to file mysql
SQL
2 votes264 views1 answer
Convert series number to date in sql
SQL
1 vote287 views1 answer
Calculate age in sql postgresql
SQL
-2 votes312 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote299 views1 answer
Mysql DDL
SQL
0 vote299 views1 answer
Automated psql csv export script on windows
SQL
0 vote311 views1 answer
The fetch keyword oracle
SQL
8 votes304 views1 answer
Oracle search code in packages
SQL
0 vote314 views1 answer
Get clob size oracle
SQL
0 vote287 views1 answer
What is ssrs and ssis in sql server
SQL