var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Update stats slowing down SP
I have a strange behaviour in my sybase database server. I am truncating a table and then do a bcp in and then I do update stats on that table and a SP is executed to update this table.
When same SP is executed without update statistics, it takes 3/4 of the time which is taken with update stats.
Will sp_recompile help in such a case ?
Last edited by Wilson77; 03-22-06 at 11:25.
In general you should run sp_recompile on the objects for which you run update stats. Otherwise the SP will use the query plan that was previously generated.