Using a stored procedure to access index configuration data in a remote database management system

摘要

An index advisor specifies an optimal index configuration for use in performing workloads against a database managed by a database management system. If the database and database management system are remotely located from the index advisor, then the index advisor invokes a stored procedure in the database management system in order to obtain information for the optimal index configuration.