SQL Daily (@sqldaily) on Piclur: Index scalar values in #JSON arrays stored in Oracle Database withCREATE MULTIVALUE INDEX ... ON t ( t.json_data.array.&lt;type&gt; )The optimizer can use these indexes when searching the array withJSON_EXISTS ( t.json_data, ' $.array? ( @.&lt;type&gt; == ... ) ' / Piclur

SQL Daily

Oct 2

Index scalar values in #JSON arrays stored in Oracle Database with CREATE MULTIVALUE INDEX ... ON t ( t.json_data.array.<type> ) The optimizer can use these indexes when searching the array with JSON_EXISTS ( t.json_data, ' $.array? ( @.<type> == ... ) '

sqldaily's tweet image. Index scalar values in #JSON arrays stored in Oracle Database with

CREATE MULTIVALUE INDEX ... ON t ( t.json_data.array.&lt;type&gt; )

The optimizer can use these indexes when searching the array with

JSON_EXISTS ( t.json_data, ' $.array? ( @.&lt;type&gt; == ... ) '

United States Trends

1. Broncos 30.4K posts
2. Raiders 41K posts
3. #911onABC 20.5K posts
4. Bo Nix 5,733 posts
5. AJ Cole N/A
6. GTA 6 18.8K posts
7. #WickedOneWonderfulNight 2,095 posts
8. eddie 41.3K posts
9. Chip Kelly N/A
10. #TNFonPrime 2,523 posts
11. Crawshaw N/A
12. Ravi 15.1K posts
13. Cynthia 34K posts
14. tim minear 2,227 posts
15. #RaiderNation 2,474 posts
16. Geno Smith 1,439 posts
17. #RHOC 1,801 posts
18. Al Michaels N/A
19. Jeanty 3,975 posts
20. GTA VI 27.8K posts

Something went wrong.