Home Forums SQL Server 2005 Administering Stored Procuders which has multiple execution plans RE: Stored Procuders which has multiple execution plans
ps.
One Orange Chip
Points: 29422
More actions
November 16, 2010 at 4:55 am
#1251230
In some cases, query processor may keep two plans, 1) without using parallelism, 2) using parallism and use either of them.
beyond that, i cant think why you are seeing several plans for one sp.