Optimize SQL if shared column predicate is being checked for every discriminator in a complete discriminator mapping
Open
area-perf
area-query
- Dominant language
- C#
- Stars
- 14.8k
- Forks
- 3.4k
- PR merge metrics
- PR metrics pending
Description
With the fix for #29913, SQL logic will be if (column_predicate and discriminator1 matches) or (column_predicate and discriminator2 matches) and so on. If this results in matching all the discriminators where the shared column is used, then the discriminator matches can be optimized away.
Contributor guide
Assessment
This issue has not been assessed yet.