Analyze Table/Index SQL
Syntax SQL Analyze Table
analyze table <<table_name>> compute statistics;
Example :
analyze table course compute statistics;
Syntax SQL Analyze Index
analyze index <<table_name>> compute statistics;
Example :
analyze index course compute statistics;