sp_iqjoinindexsize procedure

Function

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.

Table 7-40: 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