Hi,

optimize the query use some following steps :

select query from condition joins with (nolock).

declare table variable in your stored procedure if you have any condtions like groupby or where condition.This...