Home » RDBMS Server » Performance Tuning » More Hash Value (Oracle 10g)
More Hash Value [message #606503] Sat, 25 January 2014 00:23 Go to next message
shakthi@chettinadmail.com
Messages: 1
Registered: January 2008
Location: karur
Junior Member

Dear Friends.

Pls find the Plan Details when query executive
SELECT STATEMENT Optimizer=ALL_ROWS (Cost=7442)
 PX COORDINATOR
  PX SEND* (QC (ORDER)) OF :TQ10005 (Cost=7442 Cardinality=18 Bytes=3942)
   SORT* (ORDER BY) (Cost=7442 Cardinality=18 Bytes=3942)
    PX RECEIVE* (Cost=7441 Cardinality=18 Bytes=3942)
     PX SEND* (RANGE) OF :TQ10004 (Cost=7441 Cardinality=18 Bytes=3942)
      BUFFER* (SORT) (Cardinality=18 Bytes=3942)
       NESTED LOOPS* (Cost=7441 Cardinality=18 Bytes=3942)
        NESTED LOOPS* (Cost=7441 Cardinality=18 Bytes=3510)
         HASH JOIN* (Cost=7276 Cardinality=1695 Bytes=288150)
          BUFFER* (SORT)
           PX RECEIVE* (Cost=2802 Cardinality=2788 Bytes=206312)
            PX SEND* (HASH) OF :TQ10001 (Cost=2802 Cardinality=2788 Bytes=206312)
             TABLE ACCESS (FULL) OF PLANT_LOGISTICS_ASSIGNMENT (TABLE) (Cost=2802 Cardinality=2788 Bytes=206312)
          PX RECEIVE* (Cost=4473 Cardinality=581323 Bytes=55807008)
           PX SEND* (HASH) OF :TQ10003 (Cost=4473 Cardinality=581323 Bytes=55807008)
            HASH JOIN* (Cost=4473 Cardinality=581323 Bytes=55807008)
             PX RECEIVE* (Cost=2 Cardinality=1022 Bytes=43946)
              PX SEND* (HASH) OF :TQ10002 (Cost=2 Cardinality=1022 Bytes=43946)
               PX BLOCK* (ITERATOR) (Cost=2 Cardinality=1022 Bytes=43946)
                TABLE ACCESS* (FULL) OF MRP_REC (TABLE) (Cost=2 Cardinality=1022 Bytes=43946)
             BUFFER* (SORT)
              PX RECEIVE* (Cost=4470 Cardinality=955599 Bytes=50646747)
               PX SEND* (HASH) OF :TQ10000 (Cost=4470 Cardinality=955599 Bytes=50646747)
                TABLE ACCESS (FULL) OF ORDER_REC (TABLE) (Cost=4470 Cardinality=955599 Bytes=50646747)
         TABLE ACCESS* (BY INDEX ROWID) OF ORDER_REC_DELIVERY_SCHEDULE (TABLE) (Cost=3 Cardinality=1 Bytes=25)
          INDEX* (RANGE SCAN) OF ORDER_REC_DELIVERY_SCHEDULE (INDEX (UNIQUE)) (Cost=2 Cardinality=1)
        TABLE ACCESS* (BY INDEX ROWID) OF CONT_REC (TABLE) (Cost=1 Cardinality=1 Bytes=24)
         INDEX* (UNIQUE SCAN) OF SYS_C005597 (INDEX (UNIQUE)) (Cost=0 Cardinality=1)


======================================================================================


Pls help us to solve the issues
*BlackSwan added {code} tags. Please do so yourself in the future.

[Updated on: Sat, 25 January 2014 00:34] by Moderator

Report message to a moderator

Re: More Hash Value [message #606504 is a reply to message #606503] Sat, 25 January 2014 00:35 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Pls help us to solve the issues
What issue?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Previous Topic: DB in snail's pace or bad SQL query or bad DB design?
Next Topic: Is this example correct?
Goto Forum:
  


Current Time: Thu Mar 28 16:00:23 CDT 2024