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 vote126 views2 answers
Mssql show database size
SQL
15 votes140 views2 answers
Sql order by multiple columns
SQL
0 vote125 views1 answer
Oracle for loop on list
SQL
11 votes136 views2 answers
Oracle source code
SQL
5 votes125 views1 answer
Sysdate in oracle sql
SQL
0 vote142 views1 answer
Oracle last connexion
SQL
0 vote168 views1 answer
Get initials name in sql
SQL
5 votes127 views1 answer
Mysql select greater than yesterday
SQL
0 vote130 views1 answer
Exec procedure oracle
SQL
0 vote156 views1 answer
Copy row from db to db mysql
SQL