Timeline for Rerunning query in the same connection takes significantly longer
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2020 at 22:23 | history | edited | CommunityBot |
added [query-performance] to 2412 questions - Shog9 (Id=1924)
|
|
| Jul 20, 2016 at 19:45 | vote | accept | Codingrunr | ||
| May 9, 2014 at 11:47 | answer | added | Michael Green | timeline score: 1 | |
| May 8, 2014 at 20:21 | comment | added | Codingrunr | @Kin Yes the indexes and stats are up to date.I will compare the query plans. Thanks for the ideas. | |
| May 7, 2014 at 17:38 | review | First posts | |||
| May 7, 2014 at 18:10 | |||||
| May 7, 2014 at 17:27 | comment | added | Hannah Vernon♦ | Have you looked at execution plans for the "fast" and "slow" versions? Are they exactly the same? If not, therein lieth your answer. Check this answer for some real gold: dba.stackexchange.com/a/60181/10832 | |
| May 7, 2014 at 17:26 | comment | added | Kin Shah | suggest you to look into the difference between execution plans for - when the query runs fast and when it runs slow. Are stats and indexes up-to-date ? | |
| May 7, 2014 at 17:22 | history | asked | Codingrunr | CC BY-SA 3.0 |