schema stats

on November 11, 2008 at 4:15 pm
Posted In: Oracle DB and SQL performance analysis (Cat)

exec dbms_stats.gather_schema_stats(ownname=>’GARY’,GRANULARITY=>’ALL’,DEGREE=>4,CASCADE=>TRUE,OPTIONS=>’GATHER’);