Sql Server如何编译存储过程中逻辑流的执行计划？

I need to use the same query twice but have a slightly different where clause. I was wondering if it would be efficient to simply call the same stored proc with a bit value, and have an IF... ELSE... statement, deciding on which fields to compare. I need to use the same query twice but have a s