Or more specifically, to not use a certain plan.
Currently, we have a query that historically has used two different but similar plans. For some reason, SQL has chosen to use the plan that performs far worse on one of our databases. Since we use EF, I can't use hints to force it to use a certain plan. Can I delete the bad plan in SSMS? Will it just come back. What are my options as a DBA to get it to use the better plan (that the other 39 databases are using)?