thank you i have been askd thid in interview and i answered correct.

one more thng wanna knw, if a stored procedure has 50 Tsql statment and is it is suddenly showing slow performance how wud i trouble shoot n tune it??