Analyze Table ANALYZE TABLE testtable COMPUTE STATISTICS FOR TABLE FOR ALL INDEXES FOR ALL INDEXED COLUMNS; exit;