April 27, 2012 at 7:57 am
Gila maybe you are right but i just test it in with sqlquerystress tool and i execute 500 times perf1 and perf2 the same conditon perf1 is 10.8 second and perf2 is 7.68 seccond and this query execute about 100.000 times per a day
April 27, 2012 at 8:16 am
GilaMonster (4/27/2012)
Grant Fritchey (4/27/2012)
Focusing on nothin but reads, 23 is worse than 15. But as Gail says, this is a trivial difference. I'd only get worked up if this query were called hundreds of times a second or something.I wouldn't even get worried then. I'd get worried only if my performance analysis showed this was one of the 10 most resource-intensive queries overall in the server.
True,true. But on most of the systems I've worked, it would be.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2012 at 8:20 am
I think i will try it in production maybe i will see somethink 🙂 thanks for all..
Viewing 3 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply