Lookup and Join

Why lookup is heavy weight and join is light weight operator?

Showing Answers 1 - 3 of 3 Answers

sireesh vasantha

  • Aug 3rd, 2015
 

LOOKUP use RAM to perform operations where as JOIN use buffer to perform operations

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions