i generally don't use recompile option for my procs... execution plan is created the first time stored proc is executed and then it takes less time to execute...

plz. suggest... what are the pros & cons of recompile option.