Timeline for How can I optimize a recursive CTE inside a IVTF?
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 25 at 20:01 | comment | added | J. Mini | @JamesMcGrath MSTVFs got multiple improvements in 2019. I don't recall if parallelism is one of them, but it probably wasn't. | |
| Jan 25 at 14:09 | comment | added | James McGrath | And maybe I'm wrong, very possible, but don't MSTVFs block parallelism? The way I understand SQL Server : If a single element in a query is non-inlineable, the entire thing gets serialized. My recursive CTE is slow, but if it only uses one thread it's much MUCH worse... I mean like easily 10-20 times slower. | |
| Jan 25 at 13:53 | comment | added | James McGrath | The problem with hierarchyid is that it can't support family tree type of data. I isolated the estimation error to the simplest query I could, but in reality there's a FatherID and MotherID. In fact, my real query has 14 columns. | |
| Jan 24 at 23:05 | comment | added | Erik Reasonable Rates Darling | How would MSTVFs help? Table variables (at best) only get table cardinality for an estimate, with no statistical support like temp tables have. There’s also nothing at all in the presented query that HierarchyId would make better. | |
| S Jan 24 at 21:55 | review | First answers | |||
| Jan 25 at 0:58 | |||||
| S Jan 24 at 21:55 | history | answered | J. Mini | CC BY-SA 4.0 |