You can use SAPDBA for Informix to identify tables with new indexes (and new tables with at least one index) for which no statistics are held. For more information, see Update Statistics with SAPDBA.

• SAPDBA is installed correctly. Refer to SAPDBA Setup.
• You know how to use SAPDBA and have logged on. Refer to Starting SAPDBA.

Choose Update Statistics ® Tables with Non-Updated Indexes.

After choosing this action, you see a screen with entries similar to the following examples:

	table	number
1)	dd03l	6
2)	draw	6
3)	aufk	4
...

• If you choose one of the numbers on the left of the report, you can perform update statistics on the selected table. See Updating Statistics for One Table with SAPDBA.
• The number field refers to the number of indexes on the table which have been added since the table last had an update statistics. For a table without any previous statistics, all its indexes are displayed here.
• Sort order for the report is number (descending) followed by table name.

For more information about printing the report, see Printing a SAPDBA Report.