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

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty
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;