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.


Page generated: 2025-06-03T23:35:40-05:00.