Make multilevel itembox query always select good execution plan
Uncategorized
Performance improvement. An additional parameter was introduced to switch between multilevel itembox query generation strategy:
<add key="UseTempTablesForItemboxQuery" value="false"/>
in AppSettings.config.
By default turned off, so old , CTE based query generation strategy is used.