Using the oncheck Utility to Calculate Index Size

You can also use the -pT option of the oncheck utility to estimate the size of an existing R-tree index. The syntax is as follows:

oncheck -pT dbname:tablename

The -pT option of the oncheck utility prints out space allocation information for the specified table and all the indexes that exist on the table, including R-tree indexes. For example, to display space allocation information for the circle_tab table in the shapes database, run the following command as user informix at the UNIX shell or Windows command prompt:

oncheck -pT shapes:circle_tab

For more information on the oncheck utility, refer to your IBM Informix: Administrator's Guide.