Timeline for Is OPTION (RECOMPILE) used in production environments?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 22, 2021 at 19:43 | vote | accept | D-K | ||
| Apr 22, 2021 at 1:46 | comment | added | Joshua | I had to use it for a query that we had for which there were three viable plans depending on the value a single parameter took. The wrong plan would drag the system down. Better to pay for a compile with the real values every time. | |
| Apr 21, 2021 at 16:17 | comment | added | D-K | Thanks Dan. I completely agree. It is my hope that, if I get enough feedback from high power DBAs such as yourself - I can help guide us in the right direction. Overcoming unsubstantiated fears. | |
| Apr 21, 2021 at 15:53 | history | answered | Dan Guzman | CC BY-SA 4.0 |