There is a table "t1", there is a CLOB fields "c1" save JSON is as follows:

 
{
"Publisher" : "p1", 
"Books" : [
{
"Title" : "t1", 
"Author" : "a1" 
}, 
{
"Title" : "t2", 
"Author" : "a2" 
}, 
{
"Title" : "t3", 
"Author" : "a3" 
} 
] 
} 

Query in the JSON_TABLE, query condition is the title and author,
Because the data too much, now want to add the INDEX,
Excuse me, how to add the INDEX on the (title, author)?

CodePudding user response:

Results to what kind of?