I have query, we have the successfull plan.But when ever App team runs the query they were running t
Hello Team,
Here is my scenario:
I have sql_id and I have good plan working for that query. But the plan is getting changed since App team is running stats before that batch Job. I tried to force use that plan, still it is changing. Is there a way that I can do hard enforce that plan for that query irrespective of stats been run?
This issue is on Prod, so help in getting this resolved.
Thanks,