In part 1 of my SQL Server ... can cache multiple execution plans based on the value of the parameter at execution. The way this works is that during the initial process of query optimization ...