Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    1

    Unanswered: Nested loop join

    Dear all

    Why cost of nested loop join is so high,I try to run query as follow:


    Code:
    SELECT CUSTOMER.CUST_ID,
    DETAIL.CITIZENID 
    FROM CUSTOMER CUSTOMER 					
    INNER JOIN CUSTOMER_DETAIL DETAIL  				
    ON CUSTOMER.CUST_ID = DETAIL.CUST_ID
    Attached Thumbnails Attached Thumbnails cost.png  

  2. #2
    Join Date
    Aug 2011
    Posts
    46
    probably, better question would be, what is the desired execution time for this sql and what execution time you are getting. 962 timerons are not exceptionally bad cost estimation.

  3. #3
    Join Date
    Nov 2011
    Posts
    334
    yeah, amitrai4 is right.
    Why do you think nestloop join will be a low cost join method?

Posting Permissions

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