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 vote369 views1 answer
Oracle avg
SQL
1 vote356 views1 answer
Sql server datetime vs datetime2
SQL
2 votes414 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote349 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote366 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote357 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote341 views1 answer
Mysql workbench procedure
SQL
1 vote355 views2 answers
How to add amount between date in sql
SQL
8 votes355 views2 answers
Safe update mode in mysql
SQL
0 vote378 views1 answer
Compare field sql server
SQL