Sybase 12.4.2 manual Estimating the size of a join index, 170

Estimating the size of a join index

These calculations should give you an idea of how much disk space you need for the join index. The results include the segment size in bytes, and the number of blocks. The procedure also tells you how long it will take to create the join index.

If you want to know the actual size of an existing join index, you use a different stored procedure, sp_iqjoinindexsize.

See the Adaptive Server IQ Reference Manual for syntax details of all stored procedures.

170