Performance issue with parallel hint
668816Dec 31 2009 — edited Dec 31 2009Hello,
I am using parallel hint in one select query. With help of parallel hint my performance is improved.
But its not consistent. Some times query is not using parallel hint and sometimes use parallel hint.
When parallel hint used performnace is good but when parallel hint not used performance degrade.
For temporary solution i have used stored outline to fix the execution plan.
Can anybody explain what to do in such situation?
Thank you.