Timeline for Is a Clustered Index Scan bad for performance?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 23, 2019 at 6:32 | vote | accept | Paul Meems | ||
| Oct 23, 2019 at 6:32 | comment | added | Paul Meems | It seems I completely forgot to get back on this. I tried the temp table, it was just a small change in my query and it performed lightning fast. Seconds instead of hours. I'll mark your reply as the answer. | |
| Sep 19, 2019 at 12:06 | comment | added | Paul Meems | Thanks @Alocyte, I'll have a look at the temp table. What would you recommend for the COALESCE part or should I add it as a new column in the temp table? | |
| Sep 19, 2019 at 10:48 | history | answered | Alocyte | CC BY-SA 4.0 |