Hello again ! Well it's slow partly because of the linear scan but there are not too many records 5000.
I also tried with "indexed by" but: _______ sql = "select? json_extract(json, '$.value') AS val? from json_tbl indexed by json_tbl_idx where val = ?;"; showPlan(); ? AN ERROR HAS OCCURED [no query solution] _______ Cheers ! ?