On Thu, Jul 4, 2024 at 12:38 PM Lok P <loknath(dot)73(at)gmail(dot)com> wrote:
>
> Should we break the single transaction into multiple tables like one main
> table and other addenda tables with the same primary key to join and fetch
> the results wherever necessary?
>
>
I would say yes. Find a way to logically group sets of columns together
and place those groups into separate tables. I'd also be looking for cases
where multiple columns really should be multiple rows. This is not
uncommon.
David J.
David J.