79361079

Date: 2025-01-16 10:05:45
Score: 2
Natty:
Report link

I ran into same problem. 90% of the time was used to generate the perfect optimized execution plan. If I add ORDERED hint, the plan is not the optimal. But the total execution time (plan + actual execution) is much faster than then perfect plan.

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Single line (0.5):
  • Low reputation (0.5):
Posted by: Paul Chu