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

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.