Beat this....

From: <DEEDSD_at_nationwide.com>
Date: Wed, 27 Mar 2013 16:44:15 -0400
Message-ID: <OF4F4CFB99.FBEDC488-ON85257B3B.007191B0-85257B3B.0071EA43_at_lnotes-gw.ent.nwie.net>

This was really neat. I had to look up what comes after 999 trillion to figure out the cardinality, and what comes after 999 quadrillion to figure out the cost (I added commas for clarity...) SELECT STATEMENT Optimizer=ALL_ROWS (Cost=18,446,744,073,709,551,615)  PX COORDINATOR
  PX SEND* (QC (ORDER)) OF :TQ10023 (Cost=18446744073709551615 Cardinality=8180028 Bytes=924343164)

   SORT* (ORDER BY) (Cost=18446744073709551615 Cardinality=8180028 Bytes=924343164)

    PX RECEIVE* (Cost=18446744073709551615 Cardinality=8180028 Bytes=924343164)

     PX SEND* (RANGE) OF :TQ10022 (Cost=18446744073709551615 Cardinality=8180028 Bytes=924343164)

      VIEW* (Cost=18446744073709551615 Cardinality=8180028 Bytes=924343164)

       WINDOW* (SORT PUSHED RANK) (Cost=18446744073709551615 Cardinality=8180028 Bytes=11959200936)

        PX RECEIVE* (Cost=18446744073709551615 Cardinality=8180028 Bytes=11959200936)

         PX SEND* (HASH) OF :TQ10021 (Cost=18446744073709551615 Cardinality=8180028 Bytes=11959200936)

          WINDOW* (CHILD PUSHED RANK) (Cost=18446744073709551615 Cardinality=8180028 Bytes=11959200936)

           VIEW* OF VW_FOJ_0 (VIEW) (Cost=18446744073709551615 Cardinality=8180028 Bytes=11959200936)

            HASH JOIN* (FULL OUTER) (Cost=18446744073709551615 Cardinality=8180028 Bytes=5431538592)

             PX RECEIVE* (Cost=18446744073709551615 Cardinality=2718226 Bytes=271822600)

              PX SEND* (HASH) OF :TQ10019 (Cost=18446744073709551615 Cardinality=2718226 Bytes=271822600)

               VIEW* (Cost=18446744073709551615 Cardinality=2718226 Bytes=271822600)

                VIEW* (Cost=18446744073709551615 Cardinality=2718226 
Bytes=307159538)
                 WINDOW* (NOSORT) (Cost=18446744073709551615 
Cardinality=2718226 Bytes=122320170)
                  SORT* (GROUP BY) (Cost=18446744073709551615 
Cardinality=2718226 Bytes=122320170)
                   PX RECEIVE* (Cost=18446744073709551615 
Cardinality=2718226 Bytes=122320170)
                    PX SEND* (HASH) OF :TQ10016 (Cost=18446744073709551615 
Cardinality=2718226 Bytes=122320170)
                     SORT* (GROUP BY) (Cost=18446744073709551615 
Cardinality=2718226 Bytes=122320170)
                      MERGE JOIN* (CARTESIAN) (Cost=18446744073709551615 
Cardinality=18446744073709551615 Bytes=18446744073709551615)
                       MERGE JOIN* (CARTESIAN) (Cost=1176362025929233152 
Cardinality=18446744073709551615 Bytes=18446744073709551615)
                        BUFFER* (SORT)
                         PX RECEIVE* (Cost=2286295610393 
Cardinality=31855153861589624 Bytes=1114930385155636864)
                          PX SEND* (BROADCAST) OF :TQ10013 

(Cost=2286295610393 Cardinality=31855153861589624
Bytes=1114930385155636864)

                           MERGE JOIN* (CARTESIAN) (Cost=2286295610393 
Cardinality=31855153861589624 Bytes=1114930385155636864)
                            BUFFER* (SORT)
                             PX RECEIVE* (Cost=11901253553 
Cardinality=2525180646975 Bytes=88381322644125)
                              PX SEND* (BROADCAST) OF :TQ10005 


(Cost=11901253553 Cardinality=2525180646975 Bytes=88381322644125)

                               MERGE JOIN (CARTESIAN) (Cost=11901253553 
Cardinality=2525180646975 Bytes=88381322644125)
                                MERGE JOIN (CARTESIAN) (Cost=14922413 
Cardinality=1894359075 Bytes=32204104275)
                                 TABLE ACCESS (FULL) OF W_EMPLOYMENT_D 


(TABLE) (Cost=8 Cardinality=291 Bytes=4074)

                                 BUFFER (SORT) (Cost=14922405 
Cardinality=6509825 Bytes=19529475)
                                  TABLE ACCESS (FULL) OF 

W_WRKFC_EVT_MONTH_F (TABLE) (Cost=51280 Cardinality=6509825 Bytes=19529475)

                                BUFFER (SORT) (Cost=11901202274 
Cardinality=1333 Bytes=23994)
                                 TABLE ACCESS (FULL) OF W_MONTH_D (TABLE) 

(Cost=6 Cardinality=1333 Bytes=23994)

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 27 2013 - 21:44:15 CET