Performance Notes  Limitations


Chapter 2: Importing Statistics For Proxy Tables

In Adaptive Server version 12.5.3, when you perform update statistics on a remote server proxy table, if the relevant table and index statistics are available, the table catalogs are imported to the local systabstats and sysstatistics.

By default, update statistics for proxy tables always attempts to import the required statistics data. But when the statistics data is unavailable or incomplete on the remote table, Component Integration Services (CIS) reverts to the prior mechanism of gathering statistic data.

You can also force CIS to revert to the prior mechanism of gathering statistic data by turning on Traceflag 11229. This allows you to obtain all data from the database, then calculating the statistics.





Copyright © 2005. Sybase Inc. All rights reserved. Limitations

View this book as PDF