Filter
Top Products
CHAPTER 1 Overview of Adaptive Server IQ System Administration
9
Table 1-2: Stored Procedures for the IQ Store
Adaptive Server Enterprise system and catalog procedures
Adaptive Server Enterprise provides system and catalog procedures to carry
out many administrative functions and to obtain system information. Adaptive
Server IQ has implemented support for some of these procedures.
Procedure name Purpose
sp_iqcheckdb Checks the validity of the current
database and repairs indexes
sp_iqcommandstats Gives statistics on execution of
various commands
sp_iqdbsize Gives the size of the current database
sp_iqdbstatistics Reports results of the most recent
sp_iqcheckdb
sp_iqestjoin
Estimates the space needed to create
join indexes for the tables you specify
sp_iqestdbspaces Estimates the number and size of
dbspaces needed for a given total
index size
sp_iqestspace Estimates the amount of space needed
to create a database, based on the
number of rows in the underlying
database tables.
sp_iqindex Lists indexes and information about
them. Omitting the parameter lists all
indexes in the database. Specifying the
table_name parameter lists indexes for
this table only.
sp_iqindexsize Gives the size of the specified index
sp_iqjoinindexsize Gives the size of the specified join
index
sp_iqstatus Displays miscellaneous status
information about the database
sp_iqtable Lists tables and information about
them. Omitting the parameter lists all
tables in the database. Specifying the
table_name parameter lists columns
for this table only.
sp_iqtablesize Gives the size of the specified table