SELECT count(*) FROM trip_performance
WHERE (SUBSTR(TRIP_CLOSE_DATE,:"SYS_B_0",:"SYS_B_1") BETWEEN :"SYS_B_2" AND :"SYS_B_3")

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.03          0          0          0           0
Execute      1      0.00       0.02          0          1          0           0
Fetch        2      5.24      71.70     226922     227081          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        4      5.24      71.76     226922     227082          0           1

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 63  (PRODUCTION)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  SORT AGGREGATE (cr=227081 r=226922 w=0 time=71702830 us)
      1   SORT AGGREGATE (cr=227081 r=226922 w=0 time=71702816 us)
  29183    FILTER  (cr=227081 r=226922 w=0 time=71696156 us)
  29183     TABLE ACCESS FULL OBJ#(33263) (cr=227081 r=226922 w=0 time=71682267 us)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      1   SORT (AGGREGATE)
      1    SORT (AGGREGATE) [:Q85439000]
              SELECT /*+ PIV_SSF */ SYS_OP_MSR(COUNT(*)) FROM (SELECT /*+
              NO_EXPAND ROWID(A2) */ A2."TRIP_CLOSE_DATE" C0 FROM
              "TRIP_PERFORMANCE" PX_GRANULE(0, BLOCK_RANGE, DYNAMIC)  A2
              WHERE :B1<=:B2 AND SUBSTR(A2."TRIP_CLOSE_DATE",TO_NUMBER(:B3),
              TO_NUMBER(:B4))>=:B5 AND SUBSTR(A2."TRIP_CLOSE_DATE",
                TO_NUMBER(:B6),TO_NUMBER(:B7))<=:B8) A1
  29183     FILTER [:Q85439000]
  29183      TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'TRIP_PERFORMANCE'
                 [:Q85439000]