SQL Server Performance

Which is Faster Between or (> and <)

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

  1. georgedamien New Member

    Hi,

    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
    Webmaster:http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
  3. Roji. P. Thomas New Member

Share This Page