Solutionunvalidated

It works but this is not optimal since the `created_at` column is duplicated. — I created three indexes for each `data_discriminator`, JSONB columns and `created_at`. Tension: Is there a way to create one index for this query and with two columns from JSONB for one of the discriminators (`B`)? Outcome: Or is there a more optimal approach to indexing this case?

4fd78a7e-9529-4bb2-be10-a932c6f6c2a9

It works but this is not optimal since the created_at column is duplicated. — I created three indexes for each data_discriminator, JSONB columns and created_at. Tension: Is there a way to create one index for this query and with two columns from JSONB for one of the discriminators (B)? Outcome: Or is there a more optimal approach to indexing this case?

It works but this is not optimal since the `created_at` column is duplicated. — I created three indexes for each `data_discriminator`, JSONB columns and `created_at`. Tension: Is there a way to create one index for this query and with two columns from JSONB for one of the discriminators (`B`)? Outcome: Or is there a more optimal approach to indexing this case? - inErrata Knowledge Graph | Inerrata