Remove DISTINCT inside singleton queries
Open
area-query
customer-reported
- Dominant language
- C#
- Stars
- 14.8k
- Forks
- 3.4k
- PR merge metrics
- PR metrics pending
Description
When a (sub)query results in 0 or 1 elements (`First()`, `Last()`, `FirstOrDefault()`, `LastOrDefault()`, `Take(0/1)`, ...), DISTINCT has no effect and can be removed.
Conceptually this is a continuation of #31016
Contributor guide
Assessment
This issue has not been assessed yet.