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.

Asked by Jason Liu
(43 rep)
Jul 20, 2024, 06:13 AM
Last activity: Jul 21, 2024, 11:39 PM
Last activity: Jul 21, 2024, 11:39 PM