4. Maintaining a Distributed Database : Register as Link with Refresh Statement—Refresh Registration
 
Share this page                  
Register as Link with Refresh Statement—Refresh Registration
Schema information in local tables can change often. Such information may relate to storage structure, unique keys, secondary indexes, number of columns, and statistics.
When schema or related table information changes in a local database that is part of a distributed database, the Ingres Star catalogs must be updated. Except for row and page counts, this is not done automatically. It must be done with the register as link with refresh statement.
For Ingres Star to take advantage of performance tuning at the local database level, tables affected should be refreshed using the register as link with refresh statement. This allows Ingres Star to use the latest table structure and secondary indexes when determining distributed query execution plans.
The register as link with refresh statement has the following format:
register object_name as link with refresh
object_name
Is the registered view or table name whose registration you are refreshing. It can be delimited with double quotes.