Date: 2025-06-06 02:50:04
Score: 3.5
Natty:
To optimize update on this table, you first need to create a clustered index. Because heap is fast when truncate and insert but NOT on update or delete.
https://learn.microsoft.com/en-us/sql/relational-databases/indexes/heaps-tables-without-clustered-indexes?view=sql-server-ver17#when-to-use-a-heap
Reasons:
- Blacklisted phrase (1): update on this
- Probably link only (1):
- Low length (1):
- No code block (0.5):
Posted by: PollusB