RE: Beat this....

From: Holvoet, Jo <jo.holvoet_at_thomascook.be>
Date: Thu, 28 Mar 2013 09:16:25 +0100
Message-ID: <CF9A39CD0F65EA49ADF70FCBF9BC2FF7045B06E5_at_SW-GNETCW-MBX02.tcads.thomascook.com>

18,446,744,073,709,551,615 = 2 ^ 64 - 1.

I'd hazard a guess that that's a limit that indeed can't be beat ...

Mvg/regards
Jo

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DEEDSD_at_nationwide.com
Sent: woensdag 27 maart 2013 21:44
To: oracle-l_at_freelists.org
Subject: Beat this....

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


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

Received on Thu Mar 28 2013 - 09:16:25 CET