Analyze or Stat

[midora]

What should i do to analyze all tables in Schema:

Should i use :
exec dbms_utility.analyze_schema('user','schema_name');(Please correct me if i am wrong on script plase)

Or should i use Stat:

exec dbms_stats.gather_schema_stats('schema_name');

[gopu_g]

I think you can use any one of the two.

[malay_biswal]

Use Gather schema stats, taht's the recommended one.

[PAVB]

Assuming you want to gather stats on Ora8i/Ora9i/Ora10g/Ora11g dbms_stats is your choice; dbms_utility has been made obsolete long time ago.

[LKBrwn_DBA]

Here is a good article on this subject.
.