Gives the size of the specified join index.
sp_iqjoinindexsize ( join_index_name )
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
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.
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 |
sp_iqjoinindexsize ( 't1t2' )
Username |
JoinIndexName |
Number of Tables |
KBytes |
Pages |
Compressed Pages |
NBlocks |
|---|---|---|---|---|---|---|
DBA |
t1t2 |
2 |
13 |
15 |
4 |
26 |
