Table of Contents
- List of Examples
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
- Part I JSON Data and Oracle Database
- Part II Store and Manage JSON Data
- Part III Insert, Update, and Load JSON Data
-
Part IV Query JSON Data
- 14 Simple Dot-Notation Access to JSON Data
- 15 SQL/JSON Path Expressions
- 16 Clauses Used in SQL Functions and Conditions for JSON
- 17 SQL/JSON Condition JSON_EXISTS
- 18 SQL/JSON Function JSON_VALUE
- 19 SQL/JSON Function JSON_QUERY
- 20 SQL/JSON Function JSON_TABLE
- 21 Full-Text Search Queries
-
22
JSON Data Guide
- 22.1 Overview of JSON Data Guide
- 22.2 Persistent Data-Guide Information: Part of a JSON Search Index
- 22.3 Data-Guide Formats and Ways of Creating a Data Guide
- 22.4 JSON Data-Guide Fields
- 22.5 Data-Dictionary Views For Persistent Data-Guide Information
- 22.6 Specifying a Preferred Name for a Field Column
- 22.7 Creating a View Over JSON Data Based on Data-Guide Information
- 22.8 Adding and Dropping Virtual Columns For JSON Fields Based on Data-Guide Information
- 22.9 Change Triggers For Data Guide-Enabled Search Index
- 22.10 Multiple Data Guides Per Document Set
- 22.11 Querying a Data Guide
- 22.12 A Flat Data Guide For Purchase-Order Documents
- 22.13 A Hierarchical Data Guide For Purchase-Order Documents
- Part V Generation of JSON Data
- Part VI PL/SQL Object Types for JSON
- Part VII GeoJSON Geographic Data
-
Part VIII Performance Tuning for JSON
- 27 Overview of Performance Tuning for JSON
-
28
Indexes for JSON Data
- 28.1 Overview of Indexing JSON Data
- 28.2 How To Tell Whether a Function-Based Index for JSON Data Is Picked Up
- 28.3 Creating Bitmap Indexes for JSON_VALUE
- 28.4 Creating B-Tree Indexes for JSON_VALUE
- 28.5 Using a JSON_VALUE Function-Based Index with JSON_TABLE Queries
- 28.6 Using a JSON_VALUE Function-Based Index with JSON_EXISTS Queries
- 28.7 Data Type Considerations for JSON_VALUE Indexing and Querying
- 28.8 Creating Multivalue Function-Based Indexes for JSON_EXISTS
- 28.9 Using a Multivalue Function-Based Index
- 28.10 Indexing Multiple JSON Fields Using a Composite B-Tree Index
- 28.11 JSON Search Index for Ad Hoc Queries and Full-Text Search
- 29 In-Memory JSON Data
- 30 JSON Query Rewrite To Use a Materialized View Over JSON_TABLE
- Appendixes
- Index