Example: Use JOIN INDEX with JSON Dot Notation - Advanced SQL Engine - Teradata Database

The example shows how to create a JOIN INDEX with portions of a JSON instance specified using JSON dot notation.

CREATE JOIN INDEX json_table_ji AS
 SELECT j.name AS Name, 
   j.age AS Age 
 FROM json_table;