/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 vote335 views1 answer
Commit transaction sql
SQL
0 vote319 views1 answer
Stop psql server windows
SQL
0 vote371 views1 answer
Cartesian product sql
SQL
7 votes335 views6 answers
Group_concat mysql
SQL
0 vote322 views1 answer
Install ms sql server management studio
SQL
0 vote366 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote342 views1 answer
Test sql query
SQL
0 vote336 views1 answer
Oracle string substitution
SQL
0 vote314 views1 answer
Sqldf change user
SQL
0 vote357 views1 answer
Drop database using terminal postgres
SQL