Which is Better ???

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  November 6, 2008 at 1:47 am

  #124600

  hi ,

  i m posting three statastics of a query execution from PROFILER.

  can any one tel me which is better?

  CPU READS WRITES DURATION

  157 4347 1 169

  78 629 0 608

  110 5266 11 776

  Please give reason so that i can have better look

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• Wilfred van Dijk

  SSCrazy Eights

  Points: 9003

  More actions

  November 6, 2008 at 3:27 am

  #894743

  I would say writing is slower compared to reading and reading is slower compared to CPU usage, but ...

  - Could you provide the statements?

  - If this query is doing the same thing, why is the 3th variant writing more than the 1st variant?

  Wilfred
  The best things in life are the simple things