Home Forums SQL Server 2008 SQL Server Newbies How do I understand 'merge join without sort'? RE: How do I understand 'merge join without sort'?
uook
Old Hand
Points: 345
More actions
August 28, 2012 at 10:14 am
#1530929
First of all, thank you Fritchey.
I recheck execution plan but I can't find any kind of sorting operations.
As you can see, table scan is used because there is no clustered index and sorting operator isn't be shown.
Isn't it weird?