curious_sqldba (3/11/2014)
No hints used .
Update:
I meant MAXDOP =1 and CTP = 5 in my original post.
This means Parallelism has been disabled at server level and SQL Server generates serial plans only.
For serial (non -parallel) plans, it shows as 0 in the query plan meaning no=parallelism. For a parallel plan you should see parallel operator in the query plan and should be able to see no of threads in it's properties.
Check this http://thesmilingdba.blogspot.com/2012/06/maxdop-and-cost-threshold-for.html
--
SQLBuddy