Examples of query execution plan
You can write some queries using the users table and
understand how query execution plan is generated.
Description of the
users
table:CREATE TABLE users (
id INTEGER,
firstName STRING,
lastName STRING,
otherNames ARRAY(RECORD(first STRING, last STRING)),
age INTEGER,
income INTEGER,
address JSON,
connections ARRAY(INTEGER),
expenses MAP(INTEGER),
PRIMARY KEY (id)
)The following index has been created in the
users
table.CREATE INDEX idx_state_city_income on Users(address.state as string,
address.city as string, income)Some 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