Oracle gather table statistics

CALL DBMS_STATS.GATHER_TABLE_STATS(
    'OWNER_NAME',
    'TABLE_NAME',
    ESTIMATE_PERCENT => 50,			-- longer but better than 1 for exec plans
    GRANULARITY => 'PARTITION',   	-- or SUBPARTITION or nothing  
    PARTNAME => 'PARTITION_NAME', 	-- or nothing
    DEGREE => 8                 	-- parallelism
);

Similar codes

0 vote262 views1 answer
Into operator in sql
SQL
0 vote256 views2 answers
How to update date in oracle
SQL
0 vote291 views1 answer
Look at running processes redshift
SQL
3 votes265 views1 answer
Oracle list dates without weekends
SQL
0 vote255 views1 answer
Sql server on mac m1
SQL
0 vote257 views1 answer
Oracle SQL join three tables and group by column
SQL
6 votes261 views1 answer
Oracle rank
SQL
3 votes276 views3 answers
1396(hy00) mysql error
SQL
6 votes265 views2 answers
If not exists insert sql
SQL
11 votes259 views2 answers
Oracle source code
SQL