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');
Results 1 to 5 of 5
Thread: Analyze or Stat
|
Click Here to Expand Forum to Full Width |