Statistics in Informix databases

For Informix databases, you can use the UPDATE STATISTICS statement to compute statistics for all tables in a database, for a particular table in the database, or for a set of columns on an individual table.

For more information on the Informix UPDATE STATISTICS statement, refer to IBM Informix Guide to SQL: Syntax manual and IBM Informix Dynamic Server Performance Guide.