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 vote221 views3 answers
PS5
SQL
1 vote160 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote170 views1 answer
Contact mysql column field
SQL
10 votes171 views1 answer
Oracle dba_dependencies
SQL
104 votes1.1K views2 answers
Like in mysql
SQL
0 vote167 views1 answer
How to insert multiple rows in mysql using laravel
SQL
1 vote176 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote154 views1 answer
Create date sql
SQL
2 votes158 views2 answers
Join update query in sql
SQL
0 vote176 views1 answer
Datatables server side filter where clause
SQL