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

-1 vote273 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote178 views1 answer
Implicit inner join table alias
SQL
0 vote246 views1 answer
How to add auto increment primary key
SQL
3 votes117 views1 answer
How to get list of synonyms in oracle
SQL
1 vote174 views1 answer
Ef core 5.0 usesqlserver not found
SQL
0 vote169 views1 answer
Alasql delete column
SQL
-2 votes169 views3 answers
Oracle tablespace usage
SQL
0 vote176 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
3 votes166 views2 answers
Current year sql
SQL
0 vote205 views3 answers
Mysql CAST(amount as float)
SQL