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 vote173 views1 answer
Fast sql column count
SQL
3 votes180 views4 answers
Show databases in sql server
SQL
0 vote169 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote165 views1 answer
Mariadb hours between two dates
SQL
1 vote165 views1 answer
Can not connect to mysql server
SQL
0 vote188 views1 answer
Nodejs sql get one to many relationship as array
SQL
4 votes177 views4 answers
Rollback in sql
SQL
0 vote185 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote168 views1 answer
How to select even id in sql
SQL
5 votes170 views1 answer
Oracle scan source ddl
SQL