1.1.1

DescriptionQuery Plan Code
QUERY-RECEIVE displays the member ID and process ID of the
data store, as well as the total aggregate time for all of the subordinate
tasks. If the query was distributed to multiple data store members,
then each member displays a separate QUERY-RECEIVE code. The
contents of multiple QUERY-RECEIVE codes are similar unless
tables are partitioned across different VMs or physical machines.
This value is linked to the RESULT-HOLDER code on the query
coordinator. All of the tasks beneath RESULT-HOLDER represent
query operators performed on the data store member.
RESULT-HOLDER
The network time that was spent sending result rows back to the
query coordinator. The target node is the query coordinator.
RESULT-SEND
The time spent processing results for the FETCH clause.ROW-COUNT
The total time spent for index entries to fetch the base row from the
table. This occurs when the projection of the query is different from
the index column.
ROWIDSCAN
Indicates a set operation (a UNION, UNION ALL, UNION
DISTINCT, INTERSECT, INTERSECT ALL, INTERSECT
SET
DISTINCT, EXCEPT, EXCEPT ALL, or EXCEPT DISTINCT
operation). See SQL Language Limitations on page 707.
A scroll insensitive cursor operation.SCROLL-INSENSITIVE
The time spent sorting rows to execute an ORDER BY, DISTINCT,
or GROUP BY clause.
SORT
The time required to scan a table.TABLESCAN
The time spent performing a UNION, UNION ALL, or UNION
DISTINCT operation of two queries. See SQL Language Limitations
on page 707.
UNION
vFabric SQLFire User's Guide278
Managing and Monitoring vFabric SQLFire