• 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