SQL Server Performance

Which is Faster Between or (> and <)

Discussion in 'General Developer Questions' started by georgedamien, Jul 31, 2006.

  1. georgedamien New Member


    In a select query when selecting a range of records with BETWEEN operator or
    with >= and <= which one is faster.
  2. FrankKalis Moderator

    There is no difference (other than the logical) between both. When you look at the execution plan, you'll find that BETWEEN is internally translated to a combination of > and < anyway.

    Frank Kalis
    Microsoft SQL Server MVP
    Heute schon gebloggt?http://www.insidesql.de/blogs
  3. Roji. P. Thomas New Member

Share This Page