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
>
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list