• Gail,

    would it be then proper to consider that on a table with search on an unindexed column the

    'WHERE @param = something or field = @param" and

    "WHERE field = @param or @param = something"

    will be returning the same elapsed time and CPU time in server execution times?

    I doubt. I can run some tests, but would assume that the second where clause should have CPU time and server execution higher than first.