Nested loop join

pakkalan · #1 (**permalink**) 01-03-12, 00:35

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

amitrai4 · #2 (**permalink**) 01-03-12, 00:53

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.

fengsun2 · #3 (**permalink**) 01-04-12, 00:53

yeah, amitrai4 is right.
Why do you think nestloop join will be a low cost join method?

Internet Services

Web Development

Digital Marketing

Consumer Tech