Source: Technet Forum > FIM 2010 : Issue discovered in FIM Update Rollup 2 tabular functions feature
If you’re using FIM 2010 Update Rollup 2 (build 4.0.3606.2), please read this post carefully: ”
FIM 2010 Update Rollup 2 (build 4.0.3606.2) contains a feature that is intended to improve Query performance in the case of certain complex queries. This “tabular functions” feature is turned off by default. The product team wanted to get experience among a controlled group of customers before announcing the feature for general use. However, we inadvertently included information about this feature in the original KB for Update Rollup 2 and have since removed it. However, we understand that information about how to turn on the feature is circulating among the FIM community. Once the feature is turned on it cannot be turned off.
The product team has discovered an issue in this feature that could return incorrect query results when the query includes at least two statements and the same attribute is referenced in the statements. For example:
[(AccountName=’A’ and JobTitle=’Developer’)
or (AccountName’=’B’ and JobTitle=’Accountant’)]
Since it is likely that typical installations will use this query pattern we strongly advise customers NOT to turn on the Set Partition feature. I’ve posted an item on the FIM Forum about this. We will update the community as we understand the issue more completely and have developed a recommendation for addressing it.
Also, if you see blogs or FIM Forum posts talking about how to turn on and use the feature we ask for your help in making those users aware of the issue and recommending that they not turn on tabular functions. If you’ve blogged yourselves about the feature please retract the post or add a note about the fact that turning on the feature is not recommended at this time.”