Fully Utilize ISOK_RESULTS.QR_Extra
Prev | D. Techniques For Making Local Extensions to Isok | Next

### Fully Utilize ISOK_RESULTS.QR_Extra

Indexing the `JSONB` ISOK_RESULTS.QR_Extra column improves performance.

If you know your `JSONB` keys, you can make a `VIEW` that exposes the value of those keys as the view's columns. Users of this view would not have to be familiar with querying `JSONB`.

More complex schemes involve putting a row-level BEFORE trigger on ISOK_RESULTS to distribute the various values appearing in ISOK_RESULTS into other tables. But doing so surely takes you past the point of diminishing returns. It is easier to modify the SQL that Isok installs. And doing so is probably also less of a long-term maintenance burden, which matters.

Prev | Up | Next
Extend Issue Classification | Home | Modify Isok's Generated SQL

Page generated: 2025-06-02T22:25:00-05:00.