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 vote197 views1 answer
Mysql grouping functions
SQL
0 vote196 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote199 views2 answers
SQL FROM
SQL
0 vote321 views1 answer
Android sqlite add column if not exists
SQL
3 votes180 views4 answers
Order by desc postgres
SQL
0 vote186 views1 answer
How to declare variable date in mysql
SQL
0 vote209 views1 answer
Sql log file inof
SQL
0 vote189 views1 answer
Insert array into mysql column
SQL
12 votes197 views4 answers
Mysql version
SQL
0 vote202 views1 answer
Top 3 salary in sql
SQL