when you use 'include actual execution plan'
when we see scans, we can put an index.. what about below:
can you improve on
PARALLELISM (Repartition Streams)
PARALLELISM (Distribute Streams)
when the cost on these are high?
is sort related only to ORDERBY or could it be other factors also?