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

10 votes181 views6 answers
Mysql set root password
SQL
0 vote143 views1 answer
How to get n result in sql
SQL
0 vote145 views1 answer
1 column values in to 1 single row in sql
SQL
8 votes157 views1 answer
Script to add datafile to tablespace
SQL
1 vote150 views1 answer
Mamp mysql path mac
SQL
2 votes156 views1 answer
Query any digits record
SQL
0 vote166 views1 answer
Postgres clear table
SQL
0 vote138 views1 answer
Mysql add comment to column
SQL
0 vote150 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote250 views1 answer
How to get all values in a table mysql in c#
SQL