It is a query that is running not a store proc, but runs very often.....The table does have a clustered index, but the search is done on a non-clustered index...I got the plan count from activity monitor>Recent Expensive Queries
Update stats is auto on the DB
I dont have a baseline but isn't 23000+ a really high plan count. The query executes within a second.
Maybe I need a better understanding of plan counts, can you please explan?
Thanks