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 vote209 views2 answers
How covert into int in maria db
SQL
0 vote260 views1 answer
Sql server rtrim everything after character
SQL
0 vote223 views1 answer
How to alter length character varying postgres
SQL
0 vote287 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote251 views1 answer
What is default mysql database password in linux
SQL
1 vote197 views1 answer
Postgres set column equal to another
SQL
0 vote203 views2 answers
Nosqlbooster query other collection
SQL
0 vote218 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote252 views1 answer
How to check rollback status in oracle
SQL
3 votes209 views3 answers
C# sql select
SQL