Which one is better? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Which one is better?

Message

From

07/10/2014 23:01:51

Kevin Goff
Pennsylvania, United States

07/10/2014 17:14:43

Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada

General information

Forum:

Microsoft SQL Server

Category:

Indexing

Title:

Re: Which one is better?

Environment versions

SQL Server:

SQL Server 2012

Application:

Web

Miscellaneous

Thread ID:

01608954

Message ID:

01608964

Views:

Michel,

Can you post the IO Statistics for both queries?

(basically, SET STATISTICS IO ON, and SET STATISTICS TIME ON), and then do screen shots of the messages area.

Curious about the IO Stats.

"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313

Map

View

Click here to load this message in the networking platform