Thanks all for the valuable suggestions.
It helps me a lot.
thnaks for thw reply.
I used the Tuning Advicer ,
but can you please suggest any modification in the query.
I want to show the hierarchy of...
This is my first entry to this forum.
i am facing one problem.
i want to optimize one query which uses the CTE (server 2005 feature).
Separate names with a comma.