1
 Follower
4
 Likes

Add the ability to add query hints to simple queries/aggregates

Aggregates & Queries
On our radar
We'd like to be able to add query hints to simple queries/aggregates without needing to use an advanced query. We have a lot of queries that we need a bit more control over. At the very least, let us select from a list like "optimize for unknown" and "option recompile".

J.Ja
Created on 7 May 2015
Comments (4)
What would you expect those particular options to do?

Cheers,
Paulo
Paulo -

In multi-tenant applications, the execution plans created by SQL Server work well for some tenants but not for others. Depending on the data in the DB, this can cause the SQL Server to go out of control.

J.Ja
Hi Justin,

Thanks, I understand the use case now. So both options you suggested refer to that same hint, correct?

Cheers,
Paulo
Paulo -

They are different ways to control the behavior of execution plans. I don't know they exact details, that came from our DBA. :D

J.Ja
views
81
Followers
1