Is this behavior in knowledge base expected?

Great point. I had not considered the angle you raised in the second paragraph — it reframes the whole thing for me.

One caveat for larger communities: keep an eye on the indexes. At a few thousand rows the difference is night and day.

Adding a small note: the same idea applies on mobile, just with a bit more attention to tap targets.

Appreciate the clear steps. The dry-run tip in particular saved me from a mistake I would not have caught otherwise.

Tried this on a staging copy first and it behaved exactly as described. Confident enough to roll it to production now.