There is no implicit indexing on columns of JSON datatype.
The JSON datatype is implemented as a subtype of the VARCHAR datatype, but extended with JSON specific functions. See: https://www.monetdb.org/Documentation/Manuals/SQLreference/Types/JSON So the JSON data is stored as a variable length string of UTF-8 characters, but only accepts valid JSON formatted data.
If you worry about speed of extracting parts of your JSON data using JSON or string functions, you should consider to store the to-be-extracted data parts in additional columns (or tables) once, and next run your queries against those pre-extracted columns (and tables). This mimics an index, which also stores data redundantly for faster access.
On 09-07-2019 01:58, Chatchawan Triperm wrote:
Hi All,
Does anyone know whether there is built-in indexing on Json datatype or not. I would like to keep my dynamic columns in Json but worry about indexing.
Regards, Chatchawan
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list