var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Nested loop join
Why cost of nested loop join is so high,I try to run query as follow:
FROM CUSTOMER CUSTOMER
INNER JOIN CUSTOMER_DETAIL DETAIL
ON CUSTOMER.CUST_ID = DETAIL.CUST_ID
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.
yeah, amitrai4 is right.
Why do you think nestloop join will be a low cost join method?