In our production database, we run jobs to extract feeds daily at offline hours. It usually completes in around 30 to 50 minutes on a normal day. But on weekends it takes 2+ hours and it has been the way it is performing for the last few months.
When checked i can see te explain plan for the week day is different from to that of week end.
why the explain plan changes only on weekend - i think It is because we run the stats gathering jobs over the weekend .
Now my question is, can i store the explain plan of that sql query executed on weekdays and reuse it on weekends?
I am aware of usage of stored outlines for this but have no approval for implementing the same on production for now. But is there any other simple way to acheive this...Please help.