Table of Contents
- List of Examples
- List of Figures
- List of Tables
- Title and Copyright Information
- 1 Get Started
- 2 Create
- 3 Manage
-
4
Develop
- Inserting, Modifying, and Deleting Data
- Simple SELECT queries
- SELECT queries on JSON collection tables
- Using Path expressions
- Using Left Outer joins with parent-child tables
- Using NESTED TABLES to join parent-child tables
- Tuning and Optimizing SQL queries
- Managing GeoJSON data
-
5
Reference
- Operators in SQL
- Sorting, Grouping & Limiting results
- Primary Expressions in SQL
- Timestamp Functions
- Functions on Strings
-
Query execution plan
- Overview of query plan
- Query 1: Using primary key index with an index range scan
- Query 2: Using primary key index with an index predicate
- Query 3: Using a secondary index with an index range scan
- Query 4: Using the primary index
- Query 5: Sort the data using a Covering index
- Query 6: Using a secondary index with an index predicate
- Query 7: Group data with fields as part of the index
- Query 8: Using the secondary index with multiple index scans
- Query 9: A SINGLE PARTITION query using a primary index
- Query 10: Group data with fields not part of any index
- Table Modelling and Design
- Handling Errors