An ordered list of versions that can be used to optimize reconciliation against the default version.
[Visual Basic .NET] Public ReadOnly Property RecommendedReconcileOrder As IEnumVersionInfo
[C#] public IEnumVersionInfo RecommendedReconcileOrder {get;}
[C++]
HRESULT get_RecommendedReconcileOrder(
IEnumVersionInfo** infoEnum
);
[C++]Parameters
infoEnum [out, retval]infoEnum is a parameter of type IEnumVersionInfo
Product Availability
Remarks
The RecommendedReconcileOrder method returns an enumeration of version names based upon the ascending order of each version's common ancestor state with respect to the DEFAULT version. If a version's common ancestor state is equal to or greater than the state the DEFAULT version references, it will not be included in the enumeration.
The method is intended to be used prior to running a compress. If all or some of the versions returned by the RecommendedReconcileOrder are reconciled based upon the enumeration's order, the compress operation will be able to move more rows from a table's versioned delta tables to the base tables. The more versions reconciled based upon the order of versions returned, more rows will be compressed to the base table.
Compressing a versioned database can improve query performance by reducing the number of rows in a versioned table's delta tables. It is recommended after compressing to update each feature dataset's DBMS table statistics by executing the IDatasetAnalyze::Analyze method interface or your DBMS specific command.