How to index a JSON property that's an array or object?
Posted by: Glide K
Date: September 11, 2016 02:24AM

Generating a virtual column is the recommended way to index a JSON property. But what if the property is an object or an array? For example, if the JSON property is an array of userIds, and I'm querying for the userId in the array so I'd want it to be indexed. What's the best approach?

Options: ReplyQuote


Subject
Views
Written By
Posted
How to index a JSON property that's an array or object?
1116
September 11, 2016 02:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.