RE: Beat this....
- From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
- To: <DEEDSD@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Mar 2013 15:53:31 -0500
And it runs in less than a second right? :-)
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
DEEDSD@xxxxxxxxxxxxxx
Sent: Wednesday, March 27, 2013 4:44 PM
To: oracle-l@xxxxxxxxxxxxx
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)
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
