Json query vs SQL query using JSON in Oracle 12c (Performance)
|Added at||2017-01-04 14:01|
I am using oracle 12c and Sql Developer with json
For this example I have the follow JSON:
So I have created the follow table for this:
The idea is persist in person column the previous JSON and use a the follow query to get that data
Talking about perfonce, I am intresting to extract some json field and add new a colum to the table to improve the response time (I don't know if that is possible)
To do this:
My question is:
What's the best way to make a query to get data? I want to reduce the response time.
Which query get the data faster ?