SQL for Data Analytics Perform fast and efficient data analysis with the power of SQL

Metadata

Highlights

JSONB: Pre-Parsed JSON While a text JSON feld needs to be parsed each time it is referenced, a JSONB value is pre-parsed, and data is stored in a decomposed binary format. This requires that the initial input be parsed up front, and the beneft is that there is a signifcant performance improvement when querying the keys or values in this feld. This is because the keys and values do not need to be parsed – they have already been extracted and stored in an accessible binary format. Note JSONB differs from JSON in a few other ways as well. First, you cannot have more than one key with the same name. Second, the key order is not preserved. Third, semantically insignifcant details, such as whitespace, are not preserved — location:

---