Calculate index size using the oncheck utility
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:tablenameThe -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_tabFor more information about the oncheck utility, refer to your Informix® Administrator's Guide.