Create Join Index with JSON Examples | JSON Data Type | Teradata Vantage - Setting Up Join Index Examples - Advanced SQL Engine - Teradata Database

Create and populate table(s) to use in subsequent example(s).

CREATE TABLE json_table(id INTEGER, j JSON(100));

INSERT INTO json_table(1, NEW JSON('{"name":"Cameron", "age":25}')); 
INSERT INTO json_table(2, NEW JSON('{"name":"Melissa", "age":24}'));