15.10 - Example: Use JOIN INDEX with a JSON Entity Reference - Teradata Database

The example shows how to use JOIN INDEX with portions of a JSON instance specified in a JSON Entity Reference.

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