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

2 votes162 views2 answers
Postgres drop column if exists
SQL
0 vote143 views1 answer
Mysqldump: error:
SQL
0 vote134 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote144 views1 answer
How much space does sql server take per row
SQL
0 vote123 views1 answer
Mysql select where field is a value
SQL
1 vote143 views1 answer
Sql server loop over query
SQL
0 vote134 views2 answers
Install phoenix
SQL
2 votes134 views3 answers
Application.properties spring boot mysql
SQL
0 vote120 views1 answer
Psql list view rules
SQL
0 vote120 views1 answer
Database traccar
SQL