Home Forums SQL Server 2008 SQL Server Newbies Which one of the below operator takes the most time for execution? RE: Which one of the below operator takes the most time for execution?

  • No way to answer that. Depends on too many factors including but not limited to row count and indexes.

    Question doesn't even make sense, IN and AND are not in the same class, one is part of a predicate, one is a logical operator that combines two predicates

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass