Observed EXPLAIN excerpts; database name normalized. Not a runtime benchmark.

  1) First, we lock LAB_DATABASE.dwhpro_stats_demo in TD_MAP1 for
     read on a reserved RowHash to prevent global deadlock.
  2) Next, we lock LAB_DATABASE.dwhpro_stats_demo in TD_MAP1 for
     read.
  3) We do an all-AMPs RETRIEVE step in TD_MAP1 from
     LAB_DATABASE.dwhpro_stats_demo by way of an all-rows scan
     with a condition of (
     "LAB_DATABASE.dwhpro_stats_demo.status_code = 'B'") into
     Spool 1 (group_amps), which is built locally on the AMPs.  The
     size of Spool 1 is estimated with no confidence to be 2,000 rows (
     64,000 bytes).  The estimated time for this step is 0.00 seconds.
  4) Finally, we send out an END TRANSACTION step to all AMPs involved
     in processing the request.
  -> The contents of Spool 1, are sent back to the user as the result
     of statement 1.  The total estimated time is 0.00 seconds.

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-

  1) First, we lock LAB_DATABASE.dwhpro_stats_demo in TD_MAP1 for
     read on a reserved RowHash to prevent global deadlock.
  2) Next, we lock LAB_DATABASE.dwhpro_stats_demo in TD_MAP1 for
     read.
  3) We do an all-AMPs RETRIEVE step in TD_MAP1 from
     LAB_DATABASE.dwhpro_stats_demo by way of an all-rows scan
     with a condition of (
     "LAB_DATABASE.dwhpro_stats_demo.status_code = 'B'") into
     Spool 1 (group_amps), which is built locally on the AMPs.  The
     size of Spool 1 is estimated with high confidence to be 200 rows (
     6,400 bytes).  The estimated time for this step is 0.00 seconds.
  4) Finally, we send out an END TRANSACTION step to all AMPs involved
     in processing the request.
  -> The contents of Spool 1, are sent back to the user as the result
     of statement 1.  The total estimated time is 0.00 seconds.

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-

  1) First, we lock LAB_DATABASE.dwhpro_stats_demo in TD_MAP1 for
     read on a reserved RowHash to prevent global deadlock.
  2) Next, we lock LAB_DATABASE.dwhpro_stats_demo in TD_MAP1 for
     read.
  3) We do an all-AMPs RETRIEVE step in TD_MAP1 from
     LAB_DATABASE.dwhpro_stats_demo by way of an all-rows scan
     with a condition of (
     "LAB_DATABASE.dwhpro_stats_demo.status_code = 'B'") into
     Spool 1 (group_amps), which is built locally on the AMPs.  The
     size of Spool 1 is estimated with high confidence to be 400 rows (
     12,800 bytes).  The estimated time for this step is 0.00 seconds.
  4) Finally, we send out an END TRANSACTION step to all AMPs involved
     in processing the request.
  -> The contents of Spool 1, are sent back to the user as the result
     of statement 1.  The total estimated time is 0.00 seconds.

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-

  1) First, we lock LAB_DATABASE.dwhpro_ji_employee in TD_MAP1
     for read on a reserved RowHash to prevent global deadlock.
  2) Next, we lock LAB_DATABASE.dwhpro_ji_employee in TD_MAP1 for
     read.
  3) We do an all-AMPs RETRIEVE step in TD_MAP1 from
     LAB_DATABASE.dwhpro_ji_employee by way of an all-rows scan
     with a condition of (
     "LAB_DATABASE.dwhpro_ji_employee.department_no = 7") into
     Spool 1 (group_amps), which is built locally on the AMPs.  The
     size of Spool 1 is estimated with high confidence to be 200 rows (
     11,000 bytes).  The estimated time for this step is 0.00 seconds.
  4) Finally, we send out an END TRANSACTION step to all AMPs involved
     in processing the request.
  -> The contents of Spool 1, are sent back to the user as the result
     of statement 1.  The total estimated time is 0.00 seconds.

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-

  1) First, we do a single-AMP RETRIEVE step from
     LAB_DATABASE.DWHPRO_JI_BY_DEPARTMENT by way of the primary
     index "LAB_DATABASE.DWHPRO_JI_BY_DEPARTMENT.department_no =
     7" with no residual conditions into Spool 1 (one-amp), which is
     built locally on that AMP.  The size of Spool 1 is estimated with
     high confidence to be 200 rows (11,000 bytes).  The estimated time
     for this step is 0.00 seconds.
  -> The contents of Spool 1, are sent back to the user as the result
     of statement 1.  The total estimated time is 0.00 seconds.

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-

  1) First, we do a single-AMP RETRIEVE step from
     LAB_DATABASE.DWHPRO_JI_EMPLOYEE_DEPARTMENT by way of the
     primary index
     "LAB_DATABASE.DWHPRO_JI_EMPLOYEE_DEPARTMENT.department_no =
     7" with no residual conditions into Spool 1 (one-amp), which is
     built locally on that AMP.  The size of Spool 1 is estimated with
     high confidence to be 200 rows (17,000 bytes).  The estimated time
     for this step is 0.00 seconds.
  -> The contents of Spool 1, are sent back to the user as the result
     of statement 1.  The total estimated time is 0.00 seconds.

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-

  1) First, we lock LAB_DATABASE.DWHPRO_JI_DEPARTMENT_TOTALS in
     TD_MAP1 for read on a reserved RowHash to prevent global deadlock.
  2) Next, we lock LAB_DATABASE.DWHPRO_JI_DEPARTMENT_TOTALS in
     TD_MAP1 for read.
  3) We do an all-AMPs RETRIEVE step in TD_MAP1 from
     LAB_DATABASE.DWHPRO_JI_DEPARTMENT_TOTALS by way of an
     all-rows scan with no residual conditions into Spool 1
     (group_amps), which is built locally on the AMPs.  The size of
     Spool 1 is estimated with high confidence to be 100 rows (5,500
     bytes).  The estimated time for this step is 0.00 seconds.
  4) Finally, we send out an END TRANSACTION step to all AMPs involved
     in processing the request.
  -> The contents of Spool 1, are sent back to the user as the result
     of statement 1.  The total estimated time is 0.00 seconds.

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-