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 votes300 views6 answers
Mysql delete duplicates
SQL
0 vote283 views4 answers
Sql limit 1 offset 1
SQL
0 vote302 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote284 views1 answer
Query on date sqlite flutter
SQL
0 vote234 views1 answer
Oracle sql replace string in clob
SQL
0 vote302 views2 answers
Oracle select
SQL
2 votes293 views1 answer
How to check grants on a package in oracle
SQL
0 vote310 views1 answer
Mysql multiple group by
SQL
0 vote284 views1 answer
Postgres full text search example
SQL
2 votes294 views2 answers
Change varchar length mysql
SQL