sp_iqestspace Procedure

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

Syntax

sp_iqestspace ( table_name, #_of_rows, iq_page_size )

Privileges

You must have EXECUTE privilege on the system procedure. You must also have one of the following system privileges:

CREATE ANY INDEX
ALTER ANY INDEX
CREATE ANY OBJECT
ALTER ANY OBJECT
You own the table

Remarks

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). This table lists the sp_iqestspace parameters.

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)