Analyze Table/ Index SQL

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;

Posted in SQL.