sp_iqestspace procedure

Function

Estimates the amount of space needed to create an index based on the number of rows in the table.

Syntax

sp_iqestspacetable_name, #_of_rows, iq_page_size )

Permissions

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

Description

Displays the amount of space that a database requires based on the number of rows in the underlying database tables and on the database IQ page size. This procedure assumes that the database was created with the default block size for the specified IQ page size (or else the estimate is incorrect). Table 7-22 lists the sp_iqestspace parameters.

Table 7-22: sp_iqestspace parameters

Name

Datatype

Description

table_name

char(256)

Name of the table

#_of_rows

int

Number of rows in the table

iq_page_size

smallint

The page size defined for the IQ segment of the database (must be a power of 2 between 65536 and 524288; the default is 131072)