sp_iqcolumnuse Procedure

Reports detailed usage information for columns accessed by the workload.

Syntax

sp_iqcolumnuse

Privileges

You must have EXECUTE privilege on the system procedure, as well as the MONITOR system privilege.

Remarks

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.