full stats

EXEC dbms_stats.gather_schema_stats('XLPSOFT', cascade=>TRUE);

 

exec dbms_stats.gather_schema_stats( -

ownname          => 'SCOTT', -

options          => 'GATHER AUTO', -

estimate_percent => dbms_stats.auto_sample_size, -

method_opt       => 'for all columns size repeat', -

degree           => 15 -

)

 

 

EXEC dbms_stats.gather_table_stats('SCOTT','EMP',cascade=>TRUE);

 

**********************************************************************

CONFIDENTIALITY: This communication, including attachments, is for the exclusive use of the

addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended

recipient, any use, copying, disclosure, or distribution or the taking of any action in reliance upon this

information is strictly prohibited. If you are not the intended recipient, please notify the sender

immediately and delete this communication and destroy all copies.

**********************************************************************