Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
waterduck
Aged Yak Warrior
982 Posts |
 Posted - 2014-01-29 : 01:40:37
|
| Comparing 2 query, both are parallelism, first query cost 16% and second query cost 84%.first query scan count/logical read are way lesser than second query.And yet second query will complete lesser time than first query. Any idea? Do take note that the query is executed multiple time and there are no physical read. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-29 : 04:00:31
|
| are speaking on parts of query batch or two separate queries altogether?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2014-01-29 : 04:56:22
|
| two separate query that return exact same result. |
|
|
|
|
|
|
query running slow