Can someone please help me out to calculate the index size. I checked using dbschema -d dbname -t tblname. I could see the index size value. Is this right method to determine the index size or is there any other menthod to estimate the index size
you can try using oncheck -pt <db_name>:<db_owner>.<table_name> <cr> from the command line and you'll see a section of values for each index after the data section of the output. Though you can specify an First extent size and next extent size when creating a table, I don't know how the First extent size and next extent size values are derived for indexes.
In the section for each index you'll see values called "Number of Pages Allocated" and "Number of Pages Used", so use whichever value is more meaningful to you and multiply by the page size (AIX has 4k pages) and you'll have a pretty good idea how much space each index is using.
Thanks a lot for your reply . I have a clarification here . No of data pages mentioned in the oncheck command doesnt match with the index size fetched using dbschema command. What is the significance of index size value which is reported using dbschema calculated.