Table of Contents
- Title and Copyright Information
- 1 Introduction to SQL for Oracle NoSQL Database
- 2 Oracle NoSQL Database Data Model
- 3 Namespace Management
- 4 Region Management
-
5
Table Management
- CREATE TABLE Statement
- SHOW TABLES Statement
- DESCRIBE TABLE Statement
- Table Hierarchies
- Using the IDENTITY Column
- Using the UUID data type
- Using the MR_COUNTER datatype
- Sequence Generator
- DROP TABLE Statement
- ALTER TABLE Statement
- Altering an IDENTITY Column
- Add or Remove a UUID column
- Add or Remove an IDENTITY column
- Add or Remove an MR_COUNTER column
- 6 SQL Query Management
-
7
Data Row Management
- INSERT Statement
- Inserting Rows with an IDENTITY Column
- Inserting rows into a table with a UUID column
- Inserting rows with an MR_COUNTER column
- Upsert statement
- Updating rows of a table with a UUID column
- DELETE Statement
- UPDATE Statement
- 8 Indexes
- 9 Query Optimization
-
10
Query Plan
- Overview of a query plan
-
Examples of query execution plan
- Example 1 : Using a covering index in a query plan with only index scans
- Example 2 : Using a covering index in a query plan with index scans and index predicates
- Example 3: Using a non-covering index in a query plan with index scans
- Example 4: Sort the data using a Covering index
- Example 5: Sort the data using a field not part of the index
- Example 6: Group the data using a Covering index
- Example 7: Group data with fields not part of the index
- 11 GeoJson Data Management
- 12 Built-in Functions