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 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote191 views1 answer
How to move a column to different spot mysql
SQL
0 vote192 views1 answer
Postgresql array to rows
SQL
1 vote163 views1 answer
Delete triger pl pg sql
SQL
0 vote176 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote168 views1 answer
Oracle list index on table
SQL
10 votes182 views1 answer
Query to find object dependencies in oracle
SQL
2 votes207 views1 answer
Python sql
SQL
-1 vote181 views5 answers
Online sql to linq generator
SQL
0 vote179 views1 answer
Set a default value for a column in sqlite
SQL