Results 1 to 5 of 5

Thread: Nested Loops

  1. #1
    Join Date
    Jan 2015
    Posts
    2

    Unanswered: Nested Loops

    Hello, I have problem with my task. I need to describe what oracle is taking steps in the implementation of Nested Loops. I made first step, but I don't know what is next step.

    Code:
    SELECT SUM(ROUND(P_DOK_MA.ILE*CEN_STA_P(P_DOK_MA.STA_P_ID, DOK_MA.DAT_W) +DECODE(DOK_MA.PSK, 'X', P_DOK_MA.WAR, 'Y', P_DOK_MA.WAR, 0),2)) 
    	FROM P_DOK_MA,DOK_MA 
    		WHERE DOK_MA.ID=P_DOK_MA.DOK_MA_ID 
    			AND P_DOK_MA.DOK_MA_ID=:B1
    Code:
    1. select P_DOK_MA.DOK_MA_ID from P_DOK_MA where P_DOK_MA.DOK_MA_ID=:B1;

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I see the post, but have no idea what question is being asked.

    How will you or I know when correct solution has been posted?

    >I need to describe what oracle is taking steps in the implementation of Nested Loops.
    what does above mean?
    why must you describe what steps Oracle is taking?
    why must NESTED LOOP be considered?

    What problem are you really trying to solve?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2015
    Posts
    2
    Look at this example:

    Code:
    SELECT MAX(DOK_MA_PZ.DAT_W) 
    	FROM DOK_MA DOK_MA_PZ, P_ZA_AW, DOK_MA 
    		WHERE DOK_MA_PZ.DOK_AW_ID = P_ZA_AW.P_DOK_AW_DOK_AW_ID 
    			AND ( 
    					P_ZA_AW.P_DOK_ZA_DOK_ZA_ID 
    						IN (SELECT P_ZA_ZA.P_DOK_ZA_DOK_ZA_ID_2 FROM P_ZA_ZA WHERE P_ZA_ZA.P_DOK_ZA_DOK_ZA_ID = DOK_MA.DOK_ZA_ID) 
    								IN (SELECT DOK_ZA_ZA.DOK_ZA_ID_2 FROM DOK_ZA_ZA WHERE DOK_ZA_ZA.DOK_ZA_ID = DOK_MA.DOK_ZA_ID)
    				)
    									AND DOK_MA.ID = :B1
    									
    
    1. select DOK_MA.DOK_ZA_ID from DOK_MA where DOK_MA.ID = :B1;
    2. SELECT DOK_ZA_ZA.DOK_ZA_ID_2 FROM DOK_ZA_ZA WHERE DOK_ZA_ZA.DOK_ZA_ID = (up);
    3. SELECT P_ZA_ZA.P_DOK_ZA_DOK_ZA_ID_2 FROM P_ZA_ZA WHERE P_ZA_ZA.P_DOK_ZA_DOK_ZA_ID = (pkt. 1);
    4. select P_ZA_AW.P_DOK_AW_DOK_AW_ID from P_ZA_AW where P_ZA_AW.P_DOK_ZA_DOK_ZA_ID IN (pkt. 3);
    5. select DOK_MA_PZ.DAT_W from dok_ma DOK_MA_PZ where DOK_MA_PZ.DOK_AW_ID = (pkt. 4);

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I see the post, but have no idea what question is being asked.

    How will you or I know when correct solution has been posted?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    Are you attempting to say that you want to review a query's access path?
    Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •