sp_iqjoinindexsize Procedure

Gives the size of the specified join index.

Syntax

sp_iqjoinindexsize ( join_index_name )

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

Description

Returns the total size of the index in bytes, KBytes,and NBlocks (IQ blocks). Also returns the number of pages required to hold the join index in memory and the number of IQ pages when the join index is compressed (on disk). You must specify the join_index_name parameter with this procedure.

sp_iqjoinindexsize columns
Column name	Description
Username	Owner of the join index
JoinIndexName	Join index for which results are returned
Number of Tables	Number of tables in the join index
KBytes	Physical object size in KB
Pages	Number of IQ pages needed to hold the object in memory
Compressed Pages	Number of IQ pages when the object is compressed (on disk)
NBlocks	Number of IQ blocks

Example

sp_iqjoinindexsize ( 't1t2' )

Username	JoinIndexName	Number of Tables	KBytes	Pages	Compressed Pages	NBlocks
DBA	t1t2	2	13	15	4	26