sp_executesql导致我的查询非常慢

I am having some issues when running sp_executesql on a database table. I am using an ORM (NHibernate) that generates a SQL query that queries one table in this case. This table has about 7 million records in it and is highly indexed. I am having some issues when running sp_execute