ThispaperexplainshowbatchesarecachedandreusedinSQLServer2005,andsuggestsbestpracticesonmaximizingreuseofcachedplans.Italsoexplainsscenariosinwhichbatchesarerecompiled,andgivesbestpracticesforreducingoreliminatingunnecessaryrecompilations.ByArunMarathe;RevisedbyShuScott