1.1.1

ManualsBrandsVMware ManualsApplicationsvFabric SQLFire

291

292

293

294

295

296

297

298

299

300

Table Of Contents

Execute the EXPLAIN command with the following query:

explain select * from flights f, flightavailability fa where

f.flight_id=fa.flight_id and f.flight_id='AA1116';

You receive output similar to:

MEMBER_PLAN

--------------------------------------------------------------------------------------------------------------------------------

ORIGINATOR curwen(26762)<v1>:24929 BEGIN TIME 2013-06-14 14:36:37.17 END

TIME 2013-06-14 14:36:37.231

DISTRIBUTION to 1 members took 341 microseconds ( message sending

min/max/avg time 369/369/369 microseconds

and receiving min/max/avg time 278/278/278 microseconds )

SEQUENTIAL-ITERATION of 14 rows took 1963 microseconds

Slowest Member Plan:

member curwen(26758):2779 begin_execution 2013-06-14 14:36:37.173

end_execution 2013-06-14 14:36:37.223

QUERY-RECEIVE execute_time 50.542 ms member_node curwen(26762)<v1>:24929

RESULT-SEND execute_time 0.055 ms member_node curwen(26762)<v1>:24929

RESULT-HOLDER execute_time 3.001 ms returned_rows 14 no_opens 1

NLJOIN (2.32%) execute_time 0.428 ms returned_rows 14 no_opens 1

TABLESCAN (51.16%) execute_time 9.426 ms returned_rows 1 no_opens

1 scan_qualifiers Column[0][0] Id: FLIGHT_ID

Operator: = AA1116 Ordered nulls: false Unknown return value:

false scanned_object APP.FLIGHTS scan_type HEAP

ROWIDSCAN (1.11%) execute_time 0.206 ms returned_rows 14 no_opens

1 node_details FLIGHTAVAILABILITY :

CONSTRAINTSCAN (45.39%) execute_time 8.362 ms returned_rows 14

no_opens 1 scan_qualifiers None scanned_object

APP.6__FLIGHTAVAILABILITY__FLIGHT_ID__SEGMENT_NUMBER:base-table:APP.FLIGHTAVAILABILITY

scan_type

node_details WHERE : ((F.FLIGHT_ID = FA.FLIGHT_ID) and true)

Fastest Member Plan: