REPLICATE / REDUCE / REDISTRIBUTE Join Hints for LEFT and RIGHT JOIN

Question

REPLICATE / REDUCE / REDISTRIBUTE Join Hints for LEFT and RIGHT JOIN

Miles Cole 6 Microsoft Employee

INNER JOIN hints are available to enforce data movement which the optimizer may not be able to identify is more efficient. Why aren't these join hints available for LEFT or RIGHT joins?

https://learn.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver15#examples--and-

Using LEFT REPLICATE JOIN, etc. will result in a syntax error.

Thanks,

HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator

2021-10-26T21:44:54.3+00:00

Hello @Miles Cole ,
Thanks for the ask and using the Microsoft Q&A platform .
At this time, we are reaching out to the internal team to get some help on this . We will update you once we hear back from them.
Thanks
Himanshu
Miles Cole 6 Reputation points Microsoft Employee

2021-11-15T15:29:35.037+00:00

@HimanshuSinha any updates?
HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator

2021-11-17T17:37:35.193+00:00

Hello @Miles Cole
Thanks for the patience , unfortunately we are not getting the kind of response from the team here . if you have a support plan you may file a support ticket, else could you please send an email to azcommunity@microsoft.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.
Subscription ID:
Subject : Attn Himanshu
Please let me know once you have done the same.

Thanks
Himanshu