Цитата:
The solution was quite simple, a custom plan was created with the OPTIMIZE FOR UNKNOWN hint, that ensured that SQL Server would not use first passed location/site values to build a plan
еще в случае InventDim нередко помогает forceselectorder