2 ms·

this corruption is not as "silent" Whether corruption is silent or not has no relation to how it can be caused. It just means that the corruption is not automa

by tremon 4y ago

this corruption is not as "silent" Whether corruption is silent or not has no relation to how it can be caused. It just means that the corruption is not automatically detected and/or resolved, and the system will happily use the corrupted data. Which seems to be the case here, as you admit that both detection and fixing require manual intervention.

mattashii 4y ago
The title implies that data is silently being corrupted, which is true, but in well-known and detectable workloads (CIC/RIC). However, contrary to what the title would make you think, once they are created the indexes do not get more corrupt over time; the corruption does not spread. Instead, they get less and less corrupt over time as the rows missing from the index are either updated in a non-HOT manner, or deleted.