I dont know how could I avoid using functions. please give me an example in my view, if it's possible.

thank you in advance.

I also post one of my functions' script.

Maryam

Here is the script of view and execution plan.

Thank u for following up.

problem solved! Ichange query to below form and it runs in less than a second.

SELECT * FROM tb_FirstLayer AS FL

WHERE EXISTS(SELECT * FROM tb_SecondLayer AS SL...

sorry for late reply. this is the actual plan for the second query. the previous plan was an estimated plan.

sorry, I didn't get u. view JobCategroryRecord doesn't have any Index. but All tables have a primary key (ID). and tables which are participate in joins have nonClustered index on...

yes. Stored Procedure didnt cause the problem, in my opinion. the Parameter that i pass to the query cause the problem.

here is the execution plan

thanx for ur reply. I read the article.

I think that there is something wrong with parameter, because when I run the query with parameter it takes 22 secs to run.

here...