All the operators in the query plan are nested inside subQuery1 that is referenced by DFESubquery. All the operators that are pushed down to the DFE engine have names that start with a DFE prefix. As mentioned above, the whole openCypher query plan is executed by the DFE, so as a ...
The following code provides an example of a nested loop join. BEGIN; CREATE TABLE public.nestedloop_test_1 ( a integer not null, b integer not null ); CALL set_table_property('public.nestedloop_test_1', 'distribution_key', 'a'); CREATE TABLE public.nestedloop_test_2 ( c integer not...
/ 5. The XML representation is constructed by combining the tags produced in step 3 for each level of the XML structure, / using `raze` to flatten the nested lists. / Overall, the `toxml` function creates a structured XML representation of the / input table in the KDB database, wi...
/* top-level structure is an array of plans */ appendStringInfoChar(es->str, '['); es->grouping_stack = lcons_int(0, es->grouping_stack); es->indent++; break; case EXPLAIN_FORMAT_YAML: es->grouping_stack = lcons_int(0, es->grouping_stack); break; }}/* * Emit the end-of...
Example: Describe fields and structure of various resources. This command describes the fields associated with each supported API resource. Fields are identified via a simple JSONPath identifier: <type>.<fieldName>[.<fieldName>] Information about each field is retrieved from the server in OpenAPI ...
We cannot talk about a new feature without an example, so let's look at a simple SELECT query: mysql> EXPLAIN FORMAT=TREE SELECT name, quantity FROM orders JOIN items i ON item_id = i.id WHERE quantity > 1000; -> Nested loop inner join (cost=49828 rows=76470) ...
This might not be too useful for a single EXPLAIN every now and then, but if we have several schemas with the same table structure and want to gather statistics about all of them in one go, we could create a procedure that does that for us: ...
The query and database structure Explaining the original EXPLAIN Optimizing a slow query using MySQL's EXPLAIN The optimized query's EXPLAIN output Conclusions I personally believe that the best way to deliver a complicated message to an audience, is by using a simple example. So in this post,...
Figure 30: Example plan output highlighting block granule processing Although block-based granules are the most common approach, there are some operations that can benefit from leveraging the underlying data structure of a partitioned table. In these cases a partition becomes a granule of work. ...
Example 3: Detailed Execution Plan with VERBOSE For even more insights, you can include the VERBOSE keyword: Code: EXPLAINVERBOSEANALYZESELECT*FROMordersWHEREcustomer_id=123; Copy Explanation: With VERBOSE, the command provides additional details about the structure and flow of the execution plan, su...