Additional query hints

[radekskl]

As per documentation, many table hints are supported. Is there a way to use query hints, like MIN_GRANT_PERCENT / MAX_GRANT_PERCENT, which should be included at the end of query?

[JonathanMagnan]

Hello @radekskl ,

In fact, all table hints are supported since we have an overload with a string that allow you to write your hint manually.

WithHint<T>(IQueryable<T> @this, string hint, params Type[] types)

We could try to add a WithQueryHint feature but you will have to write the hint manually as most of them such the both you are asking, require number.

Is that correct with you?

Best Regards,

Jon

[radekskl]

Hi @JonathanMagnan, defining full hint for such cases would work perfectly, thanks! It would also allow for disabling specific query optimizer features only for specific query.