On Mon, Mar 4, 2024 at 2:14 PM Chema <chema@xxxxxxxxxxxxx> wrote:
You do not want to do a "select star" on both tables unless you 100% need every single column and plan to actively do something with it. Especially true for large text and json columns. Also, use jsonb not json.
There's one JSON column in each table with a couple fields, and a column with long texts in Items.and earlier indicated the query was:
Select * from tenders inner join items
Cheers,
Greg
