使用LIKE和EXISTS子句时，优化数据库模式/索引以获得更快的查询结果

While implementing a tree structure over a SQL 2005 server database, the query response is taking too long ( below queries are talking more than 5 sec ) when using While implementing a tree structure over a SQL