Also if I add a new index to a table can I get the sprocs to recompile and use the new index. Obviously I could recompile the sprocs concerned or I could execute with recompile but I wondered if there's something like recompile my_sproc?
recompile table - You can't recompile a table. recompile sproc - Will recompile just that sproc. update statistics table - will update the stats on that table then recompile all sprocs that use that table
If all the data is truncated on the table is there any use running 'sp_recompile table'?
you'll probably find your sprocs will run much faster without any data