Hints Use implicit eq to simplify the query if possible. Use explicit eq only with numeric or boolean value. Use like/match/implicit equal for string value. Do not use eq/like/match with Date value. Use gt/lt/between instead.