Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2024 02:30 AM
I don't exactly understand your question, so let me try to give you a generic answer. You don't need to do anything, if you're fine with working with one table, then just go with one.
An append-only table, as the name suggests, will only contain insert operations. By using the table property "delta.appendOnly" you can also force it.
And "a not-only append" table, obviously, might contain next to inserts, also updates and deletes.
In general, there's no right or wrong answer, as it highly depends on your use case/architecture.