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 vote338 views1 answer
Query for all indexes in table postgres
SQL
0 vote333 views1 answer
Sql server isnull function nor working count
SQL
0 vote330 views1 answer
Mysql concat and use as where column
SQL
1 vote333 views1 answer
Get last week data in mysql
SQL
0 vote369 views1 answer
Primary key start from number
SQL
0 vote355 views1 answer
Oracle plsql sleep
SQL
0 vote355 views1 answer
Foreign key type uniqu mysql
SQL
4 votes320 views1 answer
Sql data types
SQL
0 vote316 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
2 votes367 views2 answers
Sql lag
SQL