sp_iqcolumnuse Procedure

Reports detailed usage information for columns accessed by the workload.

Syntax

sp_iqcolumnuse

Privileges

Requires the MONITOR system privilege. Users without the MONITOR system privilege must be granted EXECUTE permission to run the stored procedure.

Description

Columns from tables created in SYSTEM are not reported.

sp_iqcolumnuse columns
Column name	Description
TableName	Table name
ColumnName	Column name
Owner	User name of column owner
UID**	Column Unique Identifier
LastDT	Date/time of last access
NRef	Number of query references

**UID is a number assigned by the system that uniquely identifies the instance of the column (where instance is defined when an object is created).

Tip: The INDEX_ADVISOR option generates messages suggesting additional column indexes that may improve performance of one or more queries.

Example

Sample output from the sp_iqcolumnuse procedure:

TableName       ColumnName     Owner   UID             LastDT               NRef 
orders          o_orderdate    DBA                151   20070917 22:41:22..  13
orders          o_shippriority DBA                154   20070917 22:41:22..  13
lineitem        l_orderkey     DBA                186   20070917 22:41:22..  13
lineitem        l_extendedp..  DBA                191   20070917 22:41:22..  13
lineitem        l_discount     DBA                192   20070917 22:41:22..  13
lineitem        l_shipdate     DBA                196   20070917 22:41:22..  13
#tmp1           expression     DBA     10000000001218   20070917 22:57:36..   1
#tmp1           expression     DBA     10000000001222   20070917 22:41:58..   1
...

Note: The long numbers in the example above are temporary IDs.