Updating Index Statistics

From ExxtremeWiki
Jump to: navigation, search

For Oracle I prefer:

BEGIN
     dbms_stats.gather_schema_stats
     (ownname => 'MAXIMO',
      method_opt => 'for all indexes for all indexed columns size auto',
          cascade => TRUE,
          degree => 4);
END;
/

--Will (talk) 08:48, 7 May 2014 (CDT)