Home Forums Article Discussions Article Discussions by Author Discuss content posted by John Hick The Elusive Conditional WHERE Clause RE: The Elusive Conditional WHERE Clause

  • April 17, 2015 at 9:09 pm

    #1791795

    spaghettidba (4/17/2015)

    craig 81366 (4/18/2013)

    John Hick-456673 (4/18/2013)

    I have tested it against large tables (1 billion plus rows) and performance is much better than with dynamic SQL.

    I'm going to be blunt here.

    I find that extremely hard to believe.

    +1

    Dynamic SQL is difficult to beat in this case.

    I would go as far as to say that suggesting this technique is a bad advice.

    You are two years behind the eight-ball, there. But, thank you for playing. 😀