sp_iqindexinfo Procedure

Syntax

sp_iqindexinfo ‘{ database 
| [ table table-name | index index-name ] [...] } 
[ resources resource-percent ]’

Permissions

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

Usage

You can request index information for the entire database, or you can specify any number of table or index parameters. If a table name is specified, sp_iqindexinfo returns information on all indexes in the table. If an index name is specified, only the information on that index is returned.

You cannot specify a join index by name. Use the database keyword to display join indexes.

If the specified table-name or index-name is ambiguous or the object cannot be found, an error is returned.

By default in a multiplex database, sp_iqindexinfo displays information about the shared IQ store on a secondary node. If individual tables or indexes are specified, the store to display is automatically selected.

resource-percent must be an integer greater than 0. The resources percentage allows you to limit the CPU utilization of the sp_iqindexinfo procedure by specifying the percent of total CPUs to use.

You can use this procedure in a multiplex environment. See Using Sybase IQ Multiplex.

Description

sp_iqindexinfo shows the DBA on which dbspaces a given object resides. The DBA can use this information to determine which dbspaces must be given relocate mode to relocate the object.

The results of sp_iqindexinfo are from the point of view of the version seen by the transaction running the command. Blocks used by other versions are not shown.

Examples

sp_iqindexinfo 'table t2';