Timeline for Serial Plan in plan cache
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 19, 2018 at 15:05 | comment | added | user9516827 |
Hi..sorry for the delayed response.Since the query is generating from the application...i don't have control to add ENABLE_PARALLEL_PLAN_PREFERENCE.I wanted to add it a complex view i am using in the query,but i got error message a USE database statement is not allowed in a procedure, function or trigger.Now i am thinking of creating a plan guide.
|
|
| Jul 17, 2018 at 8:51 | comment | added | Brent Ozar | Easier, yes - but has the same problem in that it doesn’t work “permanently” as he requested. The instant someone changes anything about that part of the app, QS will fail to recognize it as the same query. (I don’t think that’s a big or anything - just noting that most people are surprised by that.) | |
| Jul 16, 2018 at 21:49 | comment | added | David Browne - Microsoft | Since this is SQL 2016 Query Store can force the plan, which is easier than using a Plan Guide. | |
| Jul 16, 2018 at 21:42 | vote | accept | user9516827 | ||
| Jul 16, 2018 at 21:38 | history | answered | Brent Ozar | CC BY-SA 4.0 |