Updating Index Statistics
From ExxtremeWiki
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; /