Re: Help calculation extents from esql-c

Hello, in my set of manuals there is a book called 'INFORMIX Guide to SQL, Tutorial'. In this manual you'll find a couple of pages (10-12 ff) explaining a complete algorithm to estimate extent-sizes (both tables and indexes). Is is too long to include here (7 pages), as I'm no good on typing. I've used this information to write a VB-Application doing an estimate according to user-defined # of rows. Hope this helps, Peter P.S.: You could be lucky and find the mentioned manual in your Windows-Clients docu-set. > > Hello, > > I need to calculate the extent size of a table on the fly. > The table exists in the database, I want to calculate the > correct extent (not use the values in systable for extent) > then drop the table and re_create the table with the new extent > sizes. > > I found a shell script in a FAQ on the web , but it depends on > a tbcheck and pulls out the "number of pages used." > > Does someone have the formula.?? >