I had to execute a query on my system and wondered how a parallel execution on single processor differs from executing the same in multiple processor,so i have used this small fragent or so colled option to force my query to run on single processor, surprisingly the results where faster when compared to multi processor execution .. Also do rember this does not apply to all queries, will be trying to find the reason for this abnormal but awesome behaviour
So how to Force Execute on Single processor?
At the end of your query just give
OPTION (MAXDOP 1)
Example:
Select *
From DB
OPTION (MAXDOP 1)
Try it out and see performance difference using the Execution Plan Tab on VS!
Like this:
Like Loading...
Thank you for any other informative blog. Where else could I am getting that type of info written in
Thank you for another informative blog. Where else could I get that type of info written in such an
You need targeted traffic to your website so why not try some for free? There is a VERY POWERFUL and
Hello There. I found your blog the use of msn. That is a really well written article. I'll make sure
I like the helpful info you provide for your articles. I'll bookmark your blog and check once more r
Hey. This is an excellent blog and a very good article on establishing remote desktop connection bet
Thank you now I might be able to go on imesssage
it's still a fatal error whenever i used curses.h. what's the problem? T___T
Leave a Comment
Comments (0)