Sample Header Ad - 728x90

What kinds of operations could cause a "Temp table changed" recompilation?

2 votes
1 answer
185 views
Frequent recompilation happens in one SP with 'Temp table changed' cause. What kinds of operations on temp table would trigger this? There are no alter and create index operations on temp table, just DMLs like 'Statistics changed' as below. Thanks. Extended event
Asked by Jason Liu (43 rep)
Jul 20, 2024, 06:13 AM
Last activity: Jul 21, 2024, 11:39 PM