Is used to verify a join filter between two tables to determine if the join filter clause is valid. This stored procedure also returns information about the supplied join filter, including if it can be used with precomputed partitions for the given table. This stored procedure is executed at the Publisher on the publication. For more information, see Optimizing Parameterized Filter Performance with Precomputed Partitions.
Is if the publication qualifies for precomputed partitions; where 1 means that precomupted partitions can be used, and 0 means that they cannot be used.
Is if the supplied filter clause includes at least one parameterized filtering function; where 1 means that a parameterized filtering function is used, and 0 means that such a function is not used.
List of the functions in the filter clause that define a parameterized filter for an article, where each function is separated by a semi-colon.
If the HOST_NAME() function is used in the filter clause, where 1 means that this function is present.
If the SUSER_SNAME() function is used in the filter clause, where 1 means that this function is present.