Some queries and their individual data composition in the different companies sometimes really require specific query tuning.
Microsoft Dynamics 365 Finance and Operations, Enterprise edition has the functionality to disable parameter usage for the entire query using forceLiterals, this will overload the queryplan cash with an individual queryplan+compile overhead for each query execution.
What if we would have additional control on the SQL hints via X++? My wish list would be:
OPTIMIZE FOR UNKNOWN (formally often enabled on SQL Instance by SQL TF 4136)
RECOMPILE (formally often added by SQL Plan Guides)