7. Understanding Ingres Star Catalogs : Mapping Ingres Star Objects : Physical Information and Statistics Mapping
 
Share this page                  
Physical Information and Statistics Mapping
If the local object is an index or table (not a view), more relevant information is transferred:
from the local database’s iihistograms to Ingres Star’s iihistograms
from the local database’s iistats to Ingres Star’s iistats
This is promoted only if the environments are compatible, that is, the hardware and operating system are the same on the local database’s node as on the distributed database’s node.
Statistics information is not promoted if the local database and distributed database are in heterogeneous environments. To obtain statistics in such an environment, you must run optimizedb.